mysql配置主从时报错及处理
1、报错信息如下：Last_SQL_Error: Error 'Can't drop database 'oldboy'; database doesn't exist' on query. Default database: 'oldboy'. Query: 'drop database oldboy'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1
1 row in set (0.00 sec)
解决处理过程：
mysql> stop slave;
Query OK, 0 rows affected (0.01 sec)
mysql> set global sql_slave_skip_counter =1;
Query OK, 0 rows affected (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.01 sec)
至此，处理完成，提示，生产环境是会丢数据的，慎用。
2、报错信息如下
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000001' at 600, the last event read from '/data/3306/mysql-bin.000001' at 600, the last byte read from '/data/3306/mysql-bin.000001' at 619.'
处理过程如下
这个错误很低级，不提了，已经解决
页:
[1]