MySQL GTID 主从修复

最新推荐文章于 2024-07-26 14:20:58 发布

weixin_33889245

最新推荐文章于 2024-07-26 14:20:58 发布

阅读量228

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/firxiao/blog/2992521

版权

2019独角兽企业重金招聘Python工程师标准>>>

解决从服务器与主服务器不同步

主库备份相应的库

# mysqldump -uroot -p xxx > xxx.sql

从库停止掉slave进城并恢复最新的备份

mysql> stop slave;
mysql> source xxx.sql;

错误:

Slave_IO_Running:No
Slave_SQL_Running:Yes
Last_IO_Error:Got fatal error1236from master when reading data from binary log:'The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.'

解决:

主库注意 GTID_EXECUTED

master>show global variables like 'GTID_EXECUTED';
+---------------+-------------------------------------------+
|Variable_name|Value|
+---------------+-------------------------------------------+
|gtid_executed|9a511b7b-7059-11e2-9a24-08002762b8af:1-14|
+---------------+-------------------------------------------+

从库注意 GTID_PURGED

slave1>reset master;
slave1>show global variables like 'GTID_EXECUTED';
+---------------+-------+
|Variable_name|Value|
+---------------+-------+
|gtid_executed||
+---------------+-------+
slave1>set global GTID_PURGED="9a511b7b-7059-11e2-9a24-08002762b8af:1-14";
slave1>start slave;
slave1>show slave status\G
[...]
Slave_IO_Running:Yes
Slave_SQL_Running:Yes
[...]