随笔分类 - MySQL维护
摘要:常见binlog增量恢复方式先解析成sql文件,再导入MySQL 1mysqlbinlog mysql-bin.000001 --start-position=n > /data/add.sql2mysqlbinlog mysql-bin.000002 ... mysql-bin.n >> /dat
阅读全文
摘要:环境信息IP port role info192.168.188.81 3316 node1 master192.168.188.82 3316 node2 slave1192.168.188.83 3316 node3 slave2CentOS Linux release 7.6.1810 (Co
阅读全文
摘要:环境信息IP port role info192.168.188.81 3316 node1 master192.168.188.82 3316 node2 slave1192.168.188.83 3316 node3 slave2CentOS Linux release 7.6.1810 (Co
阅读全文
摘要:方法一:修改系统时间 方法二:手动解析relay,卡准点位 方法三:STOP SLAVE SQL_THREAD;CHANGE MASTER TO MASTER_DELAY=0;START SLAVE SQL_THREAD; 来自叶问
阅读全文