mysql主从复制问题

来源：4-19 分布式id生成器-本地id段的设计讲解

慕田峪604633

2024-02-03

为啥每次开机，主从复制都会失灵呢？查看了下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).