mysql mgr安装 --还没写完
| ip | 数据库版本信息 | 主机名 | server-id |
| 172.6.8.24 | mysql-5.7.20 | example2.oracle.com | 330624 |
| 172.6.8.25 | mysql-5.7.20 | example3.oracle.com | 330625 |
| 172.6.8.11 | mysql-5.7.20 | rac01.example.com | 330611 |
在三台机安装mysql。
server_id=2 备注：server_id=1 server_id=3(另外两台）
gtid_mode=on
enforce_gtid_consistency=ON
master_info_repository=TABLE
relay_log_info_repository=TABLE
binlog_checksum=NONE
log_slave_updates=ON
log_bin=binlog
binlog_format=ROW
transaction_write_set_extraction = XXHASH64
loose-group_replication_group_name = 'd93ea394-6d5e-4ae2-8101-f7fd22f122aa'
loose-group_replication_start_on_boot = off
loose-group_replication_local_address = '127.0.0.1:24902' 备注： '127.0.0.1:24901' '127.0.0.1:24903' （另外两台）
loose-group_replication_group_seeds ='127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903'
loose-group_replication_bootstrap_group = off
loose-group_replication_single_primary_mode=off
loose-group_replication_enforce_update_everywhere_checks=true
重启mysql: service mysqld restart
以下命令再三个节点中执行：
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'172.16.8.%' IDENTIFIED BY 'oracle';
flush privileges;
INSTALL PLUGIN group_replication SONAME 'group_replication.so';
SHOW PLUGINS;
只在首节点中执行
mysql> CHANGE MASTER TO MASTER_USER='rpl', MASTER_PASSWORD='oracle' FOR CHANNEL 'group_replication_recovery';
mysql> SET GLOBAL group_replication_bootstrap_group = ON;