Question

MYSQL REPLICATION between mysql droplets not work. Slave_IO_Running: No

Posted February 9, 2020 94 views
MySQL

I follow by this topic
[https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql]

REPLICATION is not work

(on slave server)
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
SlaveIOState:

SlaveIORunning: No
SlaveSQLRunning: Yes
MasterSSLVerifyServerCert: No
LastIOErrno: 1593
** LastIOError: 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.**
LastSQLErrno: 0
LastSQLError:

Help me please

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hey @TanawatTor

What you need to focus on here is;
The slave I/O thread stops because master and slave have equal MySQL server UUIDs

To resolve this you should follow these steps;

Remove the file; sudo rm /var/lib/mysql/auto.cnf
Restart mysqld; service mysql restart

This needs to be done on only one of your instances.

HTH,

Andrew

Submit an Answer