6.6 MySQL主从-GTID
GTID复制:(Global Transaction ID 全局事务标识符)
GTID复制不像传统的复制方式(异步复制、半同步复制)需要找到binlog文件名和POS点,只需指定master的IP、端口、账号、密码即可,开启GTID后,执行change master to master_auto_postion=1即可,它会自动寻找到相应的位置开始同步
主服务器配置:
vim /etc/my.cnf
server-id=1
lon-bin=mysql-bin #可选
gtid_mode=on
enforce_gtid_consistency
mysql> grant replication slave on *.* to 'repluser'@'192.168.0.%' identified by '123456';
从服务器配置
vim /etc/my.cnf
server-id=2
gtid_mode=on
enforce_gtid_consistency
脚本:
mysql<< EOF
change master to
master_host='192.168.0.10',
master_port=3306,
master_user='repluser',
master_password='123456',
master_auto_position=1
EOF