JoanieBrar
JoanieBrar

Reputation: 151

In master-master/multi-master replication, who is the secondary?

Silly question, when we talk about secondaries in the context of failover behaviour, with regards to master-master/multi-master, is that basically any node other than the one that we are currently reading from or writing to?

Upvotes: 0

Views: 1117

Answers (1)

Hitesh Mundra
Hitesh Mundra

Reputation: 1588

In master-master replication both the nodes are primary and secondary. In multi master replication every node is secondary but some or all are primary.

Multi master means there many database servers over which write can perform. In order to sync with other data nodes or database server we have to read all other writes and It behaves as secondary. In master slave replication we have only one master and many slaves. Master ensures that he is only write enabled and no one can writes so no need to read any one. and it behave as primary only.

For example- mysql 5.6 replication has support master-master replication but doesn't support multi master replication. But in mysql 5.7 replication it also support multi master replication. In mongoDB It only support master - slave replication.

Upvotes: 1

Related Questions