gtid mysql user不同步,MySQL5.7 配置 GTID 主从同步

#####Master开启gtid

log-bin=mysql-bin

server-id=221

gtid_mode=on

enforce-gtid-consistency=true

replicate-ignore-db = mysql

replicate-ignore-db = information_schema

replicate-ignore-db = performance_schema

replicate_wild_ignore_table=mysql.%

replicate_wild_ignore_table=information_schema.%

replicate_wild_ignore_table=performance_schema.%

#####Slave 开启gtid

server_id=207

log-bin=mysql-bin

read_only=on

gtid_mode=on

enforce-gtid-consistency=true

master_info_repository=TABLE

relay_log_info_repository=TABLE

slave-skip-errors = 1133

replicate-ignore-db = mysql

replicate-ignore-db = information_schema

replicate-ignore-db = performance_schema

replicate_wild_ignore_table=mysql.%

replicate_wild_ignore_table=information_schema.%

replicate_wild_ignore_table=performance_schema.%

#####查看gtid开启状态

show variables like '%gtid%';

+----------------------------------+-----------+

| Variable_name | Value |

+----------------------------------+-----------+

| binlog_gtid_simple_recovery | ON |

| enforce_gtid_consistency | ON |

| gtid_executed_compression_period | 1000 |

| gtid_mode | ON |

| gtid_next | AUTOMATIC |

| gtid_owned | |

| gtid_purged | |

| session_track_gtids | OFF |

+----------------------------------+-----------+

8 rows in set (0.01 sec)

#####创建同步用户

CREATE USER 'test'@'%' IDENTIFIED BY '123456!';

GRANT REPLICATION SLAVE ON *.* TO 'test'@'%';

#####配置从库gtid复制

主库开启只读

SET @@global.read_only = ON;

从库添加配置

stop slave;

CHANGE MASTER TO

MASTER_HOST='192.168.68.31',

MASTER_USER='test',

MASTER_PASSWORD='123456',

MASTER_AUTO_POSITION = 1;

start slave;

show slave status\G

主库停用只读

SET @@global.read_only = OFF;

测试主从复制

本文由 yunweizhe 创作，采用 知识共享署名 3.0，可自由转载、引用，但需署名作者且注明文章出处。

赏个馒头吧

￥ 打赏

×Close

谢谢您的支持