[toc] ## 暴力解決 ### 基于日志點 ~~~ # 停止復制 mysql@slave> stop slave; # 備份后鎖主庫 mysql@master> flush tables with read lock; # 利用工具或者命令進行master數據備份，并從庫數據恢復 # 查看master日志文件與日志點 mysql@master> show master status; +--------------------+----------+--------------+------------------+-------------------------------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +--------------------+----------+--------------+------------------+-------------------------------------------+ | master2-bin.000002 | 21658 | | | 1913a4b9-b43f-11e9-bb4c-0242c0a81003:1-25 | +--------------------+----------+--------------+------------------+-------------------------------------------+ 1 row in set (0.01 sec) # 更新slave日志點 [root@slave] change master to master_host='master.mysql.org', master_user='slave', master_port=3306, master_password='************', master_log_file='master2-bin.000002', master_log_pos=21658; mysql@master> start slave; ~~~ ### 基于GTID #### 方案1：跳過當前事務 ~~~ # slave的my.conf增加以下配置： slave-skip-errors=1032 # 或者all # 重啟數據庫 /etc/init.d/mysqld restart # 跳過一個事務 mysql@slave>STOP SLAVE; mysql@slave>SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1 mysql@slave>slave start; ~~~ #### 方案2：重置事務 ~~~ mysql@slave> show global variables like '%gtid%' ... # 主庫執行到25 gtid_executed: 1913a4b9-b43f-11e9-bb4c-0242c0a81003:1-25 ... # 清除從庫的主從信息 mysql@slave> stop slave; mysql@slave> reset slave; mysql@slave> reset master; # 設置gtid_purged mysql@slave> set @@global.gtid_purged='1913a4b9-b43f-11e9-bb4c-0242c0a81003:1-25' # 重新設置主從同步 mysql@slave> change master to master_host='ip地址', master_port=3306, master_user='usernamet', master_password='password', master_auto_position=1; # 啟動主從 mysql@slave> start slave # 查看狀態 mysql@slave> show slave status; ~~~ ## 解決1045錯誤 1. 在主上面檢查mysql復制賬號權限 2. 安裝ping檢查兩個容器之間的ip是否能鏈接：apt-get update && apt-get install iputils-ping