mysql主从复制问题

Question

为啥每次开机，主从复制都会失灵呢？查看了下slave数据库的server_id自动变回1了。请问这个问题咋整的呢
难怪上次发现失灵了，估计每次开机，启动mysql的主从后，都会失灵，只是最近学的课程没注意到这个。

Lasr_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).

Answer 1

Danny_Idea 2024-02-03 16:29:51

给mysql的my.cnf配置文件中，加入指定server-id的配置

server-id=100

• 提问者 慕田峪604633 #1

  my.cnf配置已经指定主的server-id = 1，从的server-id = 2 了。按着老师的步骤配置的。还会有别的可能原因吗