mysql_upgrade引起的mysql replication出错

默北
MySQLmysql_upgrade引起的mysql replication出错已关闭评论9,578字数 580阅读1分56秒阅读模式

公司mysql数据库服务器版本混合着用，逐步升级。在对mysql进行mysql_upgrade操作时，导致mysql复制错误了。信息如下： 

[ERROR] Slave SQL: Query caused different errors on master and slave.     Error on master: message (format)='Column count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted' error code=1547 ; Error on slave: actual message='no error', error code=0. Default database: 'performance_schema'. Query: 'DROP DATABASE IF EXISTS performance_schema', Error_code: 0

对主库进行mysql_upgrade操作时，会对performance_schema库进行操作。文章源自运维生存时间-https://www.ttlsa.com/mysql/mysql_upgrade-induced-mysql-replication-error/

只好跳过，这些操作。文章源自运维生存时间-https://www.ttlsa.com/mysql/mysql_upgrade-induced-mysql-replication-error/ 

mysql> stop slave;
mysql> set gloabl sql_slave_skip_counter = 1;
mysql> start slave;

 文章源自运维生存时间-https://www.ttlsa.com/mysql/mysql_upgrade-induced-mysql-replication-error/

升级需谨慎，小心操作。文章源自运维生存时间-https://www.ttlsa.com/mysql/mysql_upgrade-induced-mysql-replication-error/ 文章源自运维生存时间-https://www.ttlsa.com/mysql/mysql_upgrade-induced-mysql-replication-error/

weinxin
我的微信
微信公众号
扫一扫关注运维生存时间公众号，获取最新技术文章~
默北
  • 本文由 发表于 18/10/2013 22:35:58
  • 转载请务必保留本文链接：https://www.ttlsa.com/mysql/mysql_upgrade-induced-mysql-replication-error/
  • mysql
  • mysql_upgrade
  • Replication