MySQL: UUIDs must be different for replication to work
Preparing a new MySQL Replication Infrastructure (on Ubuntu) for running System.
mysql> SHOW SLAVE STATUS , got:
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
Identified that because of the UUID duplicated. Because of the same VM copy.
$ sudo cat /var/lib/mysql/auto.cnf
[auto]
server-uuid=f3ddf669-3e76-11eb-a627-0050568dded3
[auto]
server-uuid=f3ddf669-3e76-11eb-a627-0050568dded3
Required to change it Then, auto rebuilt it.
$ sudo mv /var/lib/mysql/auto.cnf /var/lib/mysql/auto.cnf~
$ sudo systemctl restart mysql
$ sudo cat /var/lib/mysql/auto.cnf
[auto]
server-uuid=a7e111ba-45c9-11eb-b0d5-0050568db87d
[auto]
server-uuid=a7e111ba-45c9-11eb-b0d5-0050568db87d
Update