V
V
Valeriy Solovyov2015-11-30 07:33:58
MySQL
Valeriy Solovyov, 2015-11-30 07:33:58

How to do data center level replication for MySQL/MySQL fork?

Hello everyone,
I am looking for the best way to implement MySQL replication or its fork of the level of 3 data centers:

  1. 3 nodes in 3 data centers
  2. unpredictable delays from 30ms and possibly loss of connection - I have repeatedly observed short-term local connectivity problems, when it is impossible to connect from one data center to the second, but it is possible to the third.
  3. Reading exceeding writing by a thousand or more times
  4. The minimum use of traffic for replication is desirable - traffic is paid
  5. The speed of reading from the database is critical, but writing should also slow down
  6. The worst option is master-slave replication. The application may be able to read from the slaves and write to the master.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Supme, 2015-12-10
@Supme

Youtube uses this https://github.com/youtube/vitess

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question