3 ms·

I read that. How is the master-master replication working for you? Also, why didn't you rather do shrading and replication considering m-m replication is experi

• dmytton 17y ago
  The only replication we're doing is master-slave which works extremely well. The slave comes back in sync after about 10 hours and then stays up to date. The replication pairs are very interesting as it allows automated failover. WIthin your code you specify a list of the servers and it will automatically set one as the master. If that fails then the others will negotiate which one will become the master and take over without any need to change your code. Sharding is experimental and isn't documented or recommended for use at the moment so I can't comment on that. We're also using the commercial support option to guarantee us 24/7 response if something goes wrong and to get bug fixes quickly, which we have used once so far.