今天早上查看slave stauts发现如下错误:
Last_SQL_Error: Could not execute Update_rows event on table movie.test; Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again, Error_code: 1197; handler error HA_ERR_RBR_LOGGING_FAILED; the event's master log binlog.000004, end_log_pos 139200700
原来是max_binlog_cache_size设置太小的原因
增大max_binlong_cache_size,重启mysql服务即可
配置多个数据库mysql主从问题
在主数据库上写:
inlog-do-db = test1
binlog-do-db = test2
binlog-do-db = test3
在从库上面写:
replicate-do-db=test1
replicate-do-db=test2
replicate-do-db=test3