42

CentOS 7.6安装配置MySQL 5.7 GTID双主复制+Keepalived实现高可用-天道酬勤---裘悦

 4 years ago
source link: https://blog.51cto.com/qiuyue/2415102
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
一、相关概念介绍:1、GTID简介:GTID:Global Transaction ID,全局事务ID,是一个已提交事务的编号,并且是一个全局唯一的编号。MySQL 5.6版本之后在主从复制类型上新增了GTID复制。通过GTID保证了每个在master节点上提交的事务在集群中有一个唯一的ID,这种方式强化了数据库的主从一致性、故障恢复及容错能力。2、GTID工作原理:GTID用于在binlog中唯

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK