Mysql master-slave synchronization

Source: Internet
Author: User
Mysql master-slave synchronization problem description:
Log mysql-bin.00001 master 192.168.1.200
Synchronize mysql-bin.00001 from 192.168.1.201

When the master server suddenly crashes and restarts, the master server show master status shows mysql-bin.00002
At this point the slave server is still synchronizing the master server's mysql-bin.00001 log file, not automatically synchronizing the mysql-bin.00002
Synchronization can only be performed after the slave server executes stop slave and then starts slave. Is there any solution?


Reply to discussion (solution)

Temporary solution: When the master server is started, the slave server is notified to execute stop slave and start slave on the slave server.

Do you have any good solutions?

You can go to the database forum to ask

You can go to the database forum to ask

Many people should use master-slave servers here?

Write a shell script. if the master server crashes, you should know how to do it.

Using cacti and zabbix to find a mysql template, all of which are monitored in real time by mysql.

Using cacti and zabbix to find a mysql template, all of which are monitored in real time by mysql.

The method is more feasible than Shell.

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.