1主库创建表,从库会同步,但是主库一插入数据,从库就报错“Error executing row event: 'Cannot execute statement: impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT.'”
是主库binlog_format=row,而从库binlog_format=statement造成的
所以首先:stop slave;
set global binlog_format='ROW';
set binlog_format='ROW';
start slave;
就会同步了
2、mysql在启动时报错“unknown variable 'rpl_semi_sync_master_enabled=1'”,那么
输入:
/etc/init.d/mysqld restart --plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so";
也可以在my.cnf中填写plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so",多个.so可以用分号隔开
3、主从不同步还有可能是主库防火墙没有关闭
4.遇到mysql登录不了,显示找不到data/mydata/mysql.sock,发现myslq.sock消失,则运行/etc/init.d/mysqld start,如果运行失败,则输入/etc/init.d/mysqld restart --plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so",然后mysql.sock就有了,就可以启动,连接mysql了