mysql判断主从服务器_mysql主从服务器

最新推荐文章于 2021-03-23 17:46:33 发布

避嫌居主人

最新推荐文章于 2021-03-23 17:46:33 发布

阅读量154

点赞数

文章标签： mysql判断主从服务器

本文链接：https://blog.csdn.net/weixin_28769407/article/details/113947113

版权

#mysql主从服务器

mysql-bin.003673 | 106

查看错误日志

show variables like '%log_error%';

replicate-do-table=testmysql

change master to master_host='182.61.28.4',master_user='mysync',

master_password='123456',master_log_file='mysql-bin.003673',master_log_pos=511;

Slave I/O: 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). Error_code: 1593

180607 10:04:08 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.003673', position 511