mysql主从同步

server1：
vim /etc/my.cnf

添加如下内容

server_id=1
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="5b7af891-9c7c-11e8-b12d-525400b7366b"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.25.8.1:24901"
loose-group_replication_group_seeds="172.25.8.1:24901,172.25.8.2:24902,172.25.8.3:24901"
loose-group_replication_bootstrap_group= off
loose-group_replication_single_primary_mode=off
loose-group_replication_enforce_update_everywhere_checks=on
loose-group_replication_ip_whitelist="172.25.8.0/24,127.0.0.1/8"

 

/etc/init.d/mysqld  start
grep  password /var/log/mysql.log
mysql  -p
在库中执行操作
mysql>set sql_log_bin=0;
mysql>alter user root@localhost identified by 'Westos-123';
mysql>grant replication slave on *.* to rpl_user@'%' identified by 'Westos-123';
mysql> flush privileges;
mysql> reset master;
mysql> set sql_log_bin=1;
mysql> change master to master_user='rpl_user',master_password='Westos-123' for channel 'group_replication_recovery';
mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';

 

mysql> SHOW PLUGINS;
mysql> SET GLOBAL group_replication_bootstrap_group=ON;
mysql> START GROUP_REPLICATION;
mysql> SELECT * FROM performance_schema.replication_group_members;

 

server2：
vim /etc/my.cnf

 

server_id=2
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="64f38c0e-8ca8-4e48-940d-a6642e249e99"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.25.8.2:24901"
loose-group_replication_group_seeds="172.25.8.1:24901,172.25.8.2:24902,172.25.8.3:24901"
loose-group_replication_bootstrap_group= off
loose-group_replication_single_primary_mode=off
loose-group_replication_enforce_update_everywhere_checks=on
loose-group_replication_ip_whitelist="172.25.8.0/24,127.0.0.1/8"

 

/etc/init.d/mysqld  start
mysql>grep  password /var/log/mysql.log
mysql>mysql  -p

mysql>set sql_log_bin=0;
mysql> alter user root@localhost identified by 'Xubowen+007';
mysql> grant replication slave on *.* to rpl_user@'%' identified by 'Xubowen+007';
mysql> reset master;
mysql> set sql_log_bin=1;
mysql> change master to master_user='rpl_user',master_password='westos-123' for channel 'group_replication_recovery';
mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so'; 

 

mysql> SHOW PLUGINS;

 

mysql> START GROUP_REPLICATION;
mysql> SELECT * FROM performance_schema.replication_group_members;

server3
vim /etc/my.cnf

 

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="64f38c0e-8ca8-4e48-940d-a6642e249e99"
loose-group_replication_start_on_boot=off
loose-group_replication_local_address= "172.25.8.3:24901"
loose-group_replication_group_seeds="172.25.8.1:24901,172.25.8.2:24902,172.25.8.3:24901"
loose-group_replication_bootstrap_group= off
loose-group_replication_single_primary_mode=off
loose-group_replication_enforce_update_everywhere_checks=on
loose-group_replication_ip_whitelist="172.25.8.0/24,127.0.0.1/8"

 

/etc/init.d/mysqld  start
grep  password /var/log/mysql.log
mysql  -p
mysql> set sql_log_bin=0;
mysql> grant replication slave on *.* to rpl_user@'%' identified by 'Westos-123';
mysql> reset master;
mysql> set sql_log_bin=1;
mysql> change master to master_user='rpl_user',master_password='Westos-123' for channel 'group_replication_recovery';
mysql> INSTALL PLUGIN group_replication SONAME 'group_replication.so';
mysql> START GROUP_REPLICATION;
mysql> SELECT * FROM performance_schema.replication_group_members;

测试
server1中写入数据
mysql> create database test;
mysql> use test;
mysql> create table t1 (c1 int primary key,c2 text not null);
mysql> insert into t1 values(1,'luis');
server3可查看

 

server2中写入数据
mysql> use test;
mysql> insert into t1 values(3,'lucy');
server3可查看