Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted.
[master] nano my.cnf binlog_format = mixed /etc/init.d/mysql restart [slave] nano my.cnf binlog_format = mixed /etc/init.d/mysql restart show variables like "binlog_format";
Comment feed