By TanawatTor
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 ***************************
Slave_IO_State:
Slave_IO_Running: No
Slave_SQL_Running: Yes
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1593
** 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.**
Last_SQL_Errno: 0
Last_SQL_Error:
Help me please
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.