gfw - cross-border synchronization mysql problem, big headache
漂亮男人
漂亮男人 2017-05-18 10:46:41
0
2
556

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.

漂亮男人
漂亮男人

reply all(2)
伊谢尔伦

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.

PHPzhong

Parse the BINLOG yourself and synchronize it.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!