mysql主从遇到问题

今天早上查看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