How to synchronize 2 MYSQL databases on different servers?

J

jinxu2012-09-06 13:24:18

MySQL

jinxu, 2012-09-06 13:24:18

There are 2 database servers in different geographical regions (Europe, Asia). If you raise the database in Asia, then for European users everything will be terribly slow and vice versa. Users from both locations must make changes and read the database (because the master-slave solution is not suitable, the master-master seems to be also habrahabr.ru/company/bitrix/blog/146490/ collisions are possible, etc.). What else can you think of?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

F

fred, 2012-09-06
@fred

For two master-master databases, the best option you can think of. Collisions are possible at any synchronization Nobody canceled the CAP theorem. Collisions must either be resolved or the data organized in such a way that they would not exist.
I have been running two servers in the master-master for 3 years - there were problems at first, everything was gradually resolved. works great now.