About the active and standby data Synchronize.

now I have two master and slave servers. The host data will be sent to the slave in real time through Synchronize. By setting a scheduled task every minute Synchronize, it is assumed that both the host and the slave have 10 minutes of data. When the host hangs up and the standby runs for 5 minutes, the slave should have 15 minutes of data. However, when the host resumes, the host"s data Synchronize timing task will immediately overwrite the 10-minute data of the host. In this way, the data generated by the standby machine for 5 minutes is lost. Is there any good solution?

Sep.21,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e5ddb9-4449a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e5ddb9-4449a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?