M
M
mediadata2016-02-19 13:25:56
MySQL
mediadata, 2016-02-19 13:25:56

How to organize MySql (MYISAM) replication between remote data centers?

There are two servers in Asia and Europe. A server in Asia runs an application that constantly writes and updates data in MYISAM tables. The size of tables is 5-10GB. You need to replicate (or otherwise copy this data) to a server in Europe without compromising application performance. Replication speed is not critical, data may be delayed. The application is closed, there is no way to interfere with its logic, i.e. all changes must be made at the level of database servers.
What is the best way to build data replication for such a task? Replication by regular means through a remote channel will work very unstable and will greatly affect the performance of the application, because. There is a lot of data coming in and it is constantly changing. Perhaps there is some solution for hot copying data from MYISAM without performance loss?
Thank you all in advance for your thoughts/ideas.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Entelis, 2016-02-19
@DmitriyEntelis

1) In any case, it makes sense to switch to innodb, it is unlikely to affect the application logic
2) The usual master-slave, just in case row-based replication

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question