The problem is this. Our website is bilingual and serves domestic and foreign users at the same time, so we have servers at home and abroad. However, since the news about illegal VPNs from gxb some time ago, mysql master-master dual-active synchronization has failed. It has been a month now, and the daily bilateral increment is around 10,000 records. So, is there any good way to synchronize? I connected the proxy to log in to two mysql servers normally, but the direct connection overseas is blocked. The size of mysql is about 7g. The cross-border domestic cloud does not seem to be able to solve the problem of our cross-border service. The VPN of the cross-border cloud is too expensive and cannot be used.
If direct connection is not possible, then use ETL. If you have money, Infomatica is more reliable, but if you don’t have money, kettle is still relatively reliable.
Parse the BINLOG yourself and synchronize it.