MySQL synchronization failure recovery due to the same server-id

Source: Internet
Author: User

MySQL synchronization in the slave database has been stopped,

Use show slave status \ G to view Slave_IO_Running: No. The server Load balancer instance fails to be started, and no error code is displayed. The following error is reported in the mysql error Log:

090216 21:06:10 [Note] Slave: deployed ed end packet from server, apparent master shutdown:

090216 21:06:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.0444 'position 77911

090216 21:06:11 [Note] Slave: connected to master 'rsync @ 10.10.10.10: 100', replication resumed in log 'mysql-bin.0444 'at position 3306

I used the previous method for a long time. I searched from the Internet for the same server-id, and then confirmed with another colleague that another slave database was originally configured, is a direct copy of my. cnf configuration file. After changing to a different server-id, restart the slave and the synchronization becomes normal.

Related Article

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.