MySql 5.5 主从服务器配置

最新推荐文章于 2023-07-01 14:03:18 发布

蝶龙旱魁

最新推荐文章于 2023-07-01 14:03:18 发布

阅读量1k

点赞数

分类专栏： mysql

mysql 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

http://www.linuxidc.com/Linux/2013-05/84785p2.htm
http://www.linuxidc.com/Linux/2013-04/82712.htm
mysql主从：

主my.cnf:
binlog-format=ROW
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
server-id=11
report-port=33061
log-bin=master-bin.log
report-host=master.trade2cn.com
innodb_flush_log_at_trx_commit=1
sync_binlog=1

从my.cnf:
binlog-format=ROW
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
server-id=12
report-port=33062
log-bin=slave-bin.log
report-host=slave.trade2cn.com
innodb_flush_log_at_trx_commit=1
sync_binlog=1

启动mysql服务器，在主从服务器查看是否启动gtid功能
主mysql->show global variables like '%gtid%';