Master and slave have equal MySQL server UUIDs Solution

Source: Internet
Author: User
Using rsync to configure a large number of MySQL, save a lot of compilation and configuration time, with the master and slave server to modify the MY.CNF, after the discovery of data can not be synchronized

Using rsync to configure a large number of MySQL, save a lot of compilation and configuration time, with the master and slave server to modify the MY.CNF, after the discovery of data can not be synchronized,
On slave server Show slave Status:

Fatal error:the slave I/O thread stops because master and slave have MySQL server equal; These uuids must are different for replication to work.

First check:
Mysql> Show variables like ' server_id ';
+ ————— + ——-+
| variable_name | Value |
+ ————— + ——-+
| server_id | 3 |
+ ————— + ——-+

The master and subordinate are not the same, excluding the problem.

Continue to troubleshoot, find the reason is, copy the entire data directory, the auto.cnf file is also copied over, which records the database UUID, each library UUID should be different.

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

Solution, according to this 16 into the format, casually changed, restart MySQL can be.

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.