参数介绍
Replicate_Do_DB: db1
Replicate_Do_DB后面接的库名,表示同步指定的数据库。
数据库版本:MySQL5.7.25
问题
在主库执行修改用户密码的操作:
user@host 07:48: [db1]> alter user tony@'%' identified by 'asd123';
Query OK, 0 rows affected (0.00 sec)
从库主从报错
Last_Error: Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction '0b19345b-441f-11e9-9f10-068cb0301d44:44025' at master log mysql-bin-changelog.152431, end_log_pos 19387052. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.
报错具体内容
user@host 07:48: [db1] > select * from performance_schema.replication_applier_status_by_worker\G
********<