Shulou(Shulou.com)06/01 Report--

Database version: mariadb 10.0.12

Delete redundant user names in master database, cause master-slave fault because slave database does not have this information!

The error message is as follows:

Error 'Operation DROP USER failed for 'username'@'192.16.% '

Multi-source replication master-slave error Skip:

According to mysql operation mode sql_slave_skip_counter = 1, execution does not report error, but sql_slave_skip_counter = 1 will not take effect.

The operation of multi-source master-slave fault hopping is as follows:

SET @@default_master_connection = 'master_01';

SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;

STOP SLAVE 'master_01';

START SLAVE 'master_01';

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.