bitscn.com
 [mysql复制错误]last_errno: 1666 last_error: error executing row event: 'cannot execute statement: imposs
收到email报警， last_error: error executing row event: 'cannot execute statement: impossible to write to binary log since statement is in row format and binlog_format = statement.'
登陆上去mysql，看到slave_sql_running: no，信息如下：
mysql> show slave status/g*************************** 1. row *************************** slave_io_state: queueing master event to the relay log master_host: 10.105.219.37 master_user: replication master_port: 3306 connect_retry: 60 master_log_file: mysql-bin.002665 read_master_log_pos: 86809371 relay_log_file: mysql-relay-bin.006654 relay_log_pos: 5035958 relay_master_log_file: mysql-bin.002458 slave_io_running: yes slave_sql_running: no replicate_do_db: replicate_ignore_db: replicate_do_table: replicate_ignore_table: replicate_wild_do_table: replicate_wild_ignore_table: last_errno: 1666 last_error: error executing row event: 'cannot execute statement: impossible to write to binary log since statement is in row format and binlog_format = statement.' skip_counter: 0 exec_master_log_pos: 5035812 relay_log_space: 21792518676 until_condition: none until_log_file: until_log_pos: 0 master_ssl_allowed: no master_ssl_ca_file: master_ssl_ca_path: master_ssl_cert: master_ssl_cipher: master_ssl_key: seconds_behind_master: nullmaster_ssl_verify_server_cert: no last_io_errno: 0 last_io_error: last_sql_errno: 1666 last_sql_error: error executing row event: 'cannot execute statement: impossible to write to binary log since statement is in row format and binlog_format = statement.' replicate_ignore_server_ids: master_server_id: 11 r
ow in set (0.00 sec)
看到貌似是statement模式不足以应付应用，换成mixed试试看吧：
mysql> stop slave;query ok, 0 rows affected (0.02 sec)mysql> set global binlog_format=mixed;query ok, 0 rows affected (0.00 sec)mysql> start slave;query ok, 0 rows affected (0.00 sec)mysql> show slave status/g*************************** 1. row *************************** slave_io_state: waiting for master to send event master_host: 10.105.219.37 master_user: replication master_port: 3306 connect_retry: 60 master_log_file: mysql-bin.002673 read_master_log_pos: 806109 relay_log_file: mysql-relay-bin.006654 relay_log_pos: 5873558 relay_master_log_file: mysql-bin.002458 slave_io_running: yes slave_sql_running: yes replicate_do_db: replicate_ignore_db: replicate_do_table: replicate_ignore_table: replicate_wild_do_table: replicate_wild_ignore_table: last_errno: 0 last_error: skip_counter: 0 exec_master_log_pos: 5873412 relay_log_space: 22545381827 until_condition: none until_log_file: until_log_pos: 0 master_ssl_allowed: no master_ssl_ca_file: master_ssl_ca_path: master_ssl_cert: master_ssl_cipher: master_ssl_key: seconds_behind_master: 2294051master_ssl_verify_server_cert: no last_io_errno: 0 last_io_error: last_sql_errno: 0 last_sql_error: replicate_ignore_server_ids: master_server_id: 11 row in set (0.00 sec)mysql>
ok，问题已经解决了，等待seconds_behind_master: 2294051吧。
bitscn.com