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.