Related

Product Now Available: Managed MySQL Databases Product
Install MySQL on New Droplet Question Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" Question Question

Question

MYSQL REPLICATION between mysql droplets not work. Slave_IO_Running: No

Posted February 9, 2020 554 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

Add a comment
TanawatTor
By:
TanawatTor
Add a comment

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
andmoo February 10, 2020

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

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help