1

I have mysql 5.7.24 mysql version. Can i implement Multi-master replication between three nodes without to create a ring topology? Like a graph

Thanks :)

closed as unclear what you're asking by mustaccio, LowlyDBA, Md Haidar Ali Khan, hot2use, McNets Nov 7 '18 at 14:07

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

0

While technically this is possible, as MySQL 5.7 supports multisource replication, so one instance can replicate from 2 other servers, it is unlikely you want to setup that.

Regular replication does not resolve write conflicts, so those would have to be solved at application layer or it would only serve work for trivial configurations (e.g. each server working with a separate database or just doing appends to a table).

If you want a proper MySQL cluster with multi-masters and conflict resolution, check Galera/Percona XtraDB Cluster, InnoDB Cluster or NDB Cluster.

0

AWS also has a preview of the MySQL compatible Aurora database that they announced last year that supports a multi master configuration. I don’t see an estimated release date yet for general use but you can sign up to get access to the preview.

Not the answer you're looking for? Browse other questions tagged or ask your own question.