Master and slave have equal MySQL server UUIDs Solution

Source: Internet
Author: User

Rsync is used to configure a large number of mysql instances, saving a lot of time for compilation and configuration. After modifying my. cnf of the master and slave servers one by one, it is found that the data cannot be synchronized,
On the slave server, show slave status:

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.

First check:
Mysql> show variables like 'server _ id ';
+ ----- + --- +
| Variable_name | Value |
+ ----- + --- +
| Server_id | 3 |
+ ----- + --- +

The master and slave are not the same. This problem is ruled out.

Continue to troubleshoot and find out the reason: copy the entire data directory and copy the auto. cnf file, which records the uuid of the database. The uuid of each database should be different.

[Auto]
Server-uuid = 6dcee5be-8cdb-11e2-9408-90e2ba2e2ea6

Solution: Follow the hexadecimal format to change it and restart mysql.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.