实现基于gtid的主从复制
(1)在server1(master)上面进行配置
vim /etc/my.cnf
加入:开启gtid的信息
gtid_mode=ON
enforce-gtid-consistency=true
(2)在server2(slave节点)上面进行配置
vim /etc/my.cnf
加入:开启gtid的信息
gtid_mode=ON
enforce-gtid-consistency=true
systemctl restart mysqld
mysql -uroot -pLIxin123.
show databases;
stop slave;
change master to
master_host='172.25.254.10',
master_user='repl',
master_password='LIxin123.',
master_auto_position=1;
start slave;
show slave status\G;
(3)在server1上面开始写数据
show databases;
use westos
insert into usertb values ('user2','456');
insert into usertb values ('user3','789');
(4)在server2上面查看gtid的信息
show slave status\G;
use mysql
select * from gtid_+executed;
(5)在server1上面查看gtid的信息
(6)在server2上面查看复制过来的数据