CODEWITHSUNDEEP
mysqlamazon-ec2mariadb
vuliad
vuliad

Reputation: 2152

Multimaster replication with multiple slaves with MariaDB/Mysql

Is it possible to receive the following configuration with Maria DB/MySQL: Two master nodes with synchronous replication (actually need one, second need for failover and could be asynchronous ), N slaves nodes with asynchronous replication, We want to use Amazon EC2 with autoscale. What are the pitfalls? Which better for this task: Mysql or MariaDB?

Upvotes: 0

Views: 215

Answers (1)

Rick James
Rick James

Reputation: 142278

There is no "synchronous Multi-Master replication" in standard replication.

Sounds like you would benefit from MariaDB with Galera. With that, you not only get synchronous replication, but also automatic recovery from server failure.

Upvotes: 1

Related Questions