Re: Mysql Master-master replication

[Frederic Descamps]

Hi,

My first observation is that if you really want to achieve HA, having 2 nodes is not enough as it won't protect you from split-brain situation (lost of quorum).

Therefore, we at MySQL decided to ship a new easy way to handle HA for MySQL : MySQL InnoDB Cluster. This new solution, uses Group Replication and allows multi-masters (called multi-primary).

Please get familiar with it and it will solve most of your concerns.

You can find some intro on slideshare: https://www.slideshare.net/lefred.descamps
on my blog: http://lefred.be/content/category/mysql/group-replication/ and of course on our documentation: https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-getting-started.html

Best regards,

lefred.