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 :)

2 Answers 2

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.