MySQL Group Replication 部署 (Single Master)

准备3台服务器

10.0.0.201 node201

10.0.0.202 node202

10.0.0.203 node203

操作系统：centos 7.x 64

mysql: 5.7.20

采用编译源码安装以及systemctl管理

http://blog.csdn.net/chenhaifeng2016/article/details/77689270

配置node201

修改配置文件/etc/my.cnf

# # Replication configuration parameters # server_id=201 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 # # Group Replication configuration # transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "10.0.0.201:33060" loose-group_replication_group_seeds= "10.0.0.201:33060,10.0.0.202:33060,10.0.0.203:33060" loose-group_replication_bootstrap_group= off
执行以下命令

SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE,replication client ON *.* TO rpl_user@'%'; FLUSH PRIVILEGES; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery';INSTALL PLUGIN group_replication SONAME 'group_replication.so'; SET GLOBAL group_replication_bootstrap_group=ON; START GROUP_REPLICATION; SET GLOBAL group_replication_bootstrap_group=OFF;查看状态 SELECT * FROM performance_schema.replication_group_members;
配置node202

修改配置文件/etc/my.cnf

# # Replication configuration parameters # server_id=202 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# # Group Replication configuration # transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "10.0.0.202:33060" loose-group_replication_group_seeds= "10.0.0.201:33060,10.0.0.202:33060,10.0.0.203:33060" loose-group_replication_bootstrap_group= off
执行以下命令

SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%'; GRANT REPLICATION SLAVE,replication client ON *.* TO rpl_user@'%' IDENTIFIED BY 'password'; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery'; INSTALL PLUGIN group_replication SONAME 'group_replication.so'; set global group_replication_allow_local_disjoint_gtids_join=ON; START GROUP_REPLICATION;

配置node203

修改配置文件/etc/my.cnf

# # Replication configuration parameters # server_id=203 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# # Group Replication configuration # transaction_write_set_extraction=XXHASH64 loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" loose-group_replication_start_on_boot=off loose-group_replication_local_address= "10.0.0.203:33060" loose-group_replication_group_seeds= "10.0.0.201:33060,10.0.0.202:33060,10.0.0.203:33060" loose-group_replication_bootstrap_group= off
执行以下命令

SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%'; GRANT REPLICATION SLAVE,replication client ON *.* TO rpl_user@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' FOR CHANNEL 'group_replication_recovery'; INSTALL PLUGIN group_replication SONAME 'group_replication.so'; set global group_replication_allow_local_disjoint_gtids_join=ON; START GROUP_REPLICATION;

组复制部署已完成，输出结果显示node201为主节点可以读写，node202和node203只能读数据。

总结

以上是生活随笔为你收集整理的MySQL Group Replication 部署 (Single Master)的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。