其实mysql的从库 就相当于oracle的逻辑备库的概念,理解了这个解决mysql从库的问题就很轻松了
我们来模拟情况,我们在主库删除一个数据库,而从库是没有这个数据库的,此时从库就报错了
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.37.129.3
Master_User: kiwi
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000006
Read_Master_Log_Pos: 377
Relay_Log_File: mysqld-relay-bin.000006
Relay_Log_Pos: 366
Relay_Master_Log_File: mysql-bin.000006
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: 1008
Last_Error: Error 'Can't drop database 'yao&