MySQL上的“重复项”错误一直在从属中断复制
我遵循这个教程: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql 不幸的是复制停止在奴隶始终: [ERROR] Slave SQL: Error 'Duplicate entry '6443185' for key 'PRIMARY'' on query. Default database: 'testdb'. Query: 'INSERT INTO ultimate_cron_lock (name, current, expire) VALUES ('ultimate_cron_serial_launcher_1', '0', '1424077478.0243')', Error_code: 1062 如果我删除所有的dbs,那么我怎么能告诉Mysql从服务器自动创build它们? 我没有在Master上指定binlog_do_db =,这意味着它应该为所有dbs执行二进制日志,在Slave上我只忽略了几个数据库: server-id = 2 relay-log = /var/lib/mysql/binlog/mysql-relay-bin.log log_bin = /var/lib/mysql/binlog/mysql-bin.log replicate-ignore-db=test replicate-ignore-db=information_schema replicate-ignore-db=mysql 谢谢