Enjoy GreatSQL :)
1.目前的环境:master 192.168.26.233 3306
slave 192.168.26.108 3306
复制:binlog+position 传统复制
2.在线切换
1.master和slave执行
root@localhost [zw3306]>set @@global.enforce_gtid_consistency = warn
Query OK, 0 rows affected (0.00 sec)
root@localhost [zw3306]>show global variables like '%enforce_gtid_consistency%'
+--------------------------+-------+
| Variable_name| Value |
+--------------------------+-------+
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)