Mysql AB复制
MySQL AB复制 - 腾讯云开发者社区-腾讯云 (tencent.com)
看着还行,结果自己动手实验有点问题,跟想象中不一样!
Last_IO_Errno: 13117
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).
Last_SQL_Errno: 0
出现了这个
然后我在网上找到了 这个解决了
https://blog.csdn.net/cnds123321/article/details/117925881
然后又出来了一个这个问题,我没看明白,后面又自己可以同步了. 主从删掉,都可以查到了.
Last_Errno: 1008
Last_Error: Error 'Can't drop database 'db1'; database doesn't exist' on query. Default database: 'db1'
