Intermediate LevelSQL & MySQL
What is MySQL Group Replication and how does Multi-Primary master replication operate?
❓ Interview Prompt: Explain MySQL Group Replication, Paxos consensus protocol, Single-Primary vs Multi-Primary modes, and automatic conflict detection.
MySQL Group Replication provides fault-tolerant, multi-master replication with built-in consensus protocols:
Architecture:
•
Uses a Paxos-based group communication protocol to replicate transactions across cluster nodes.
•
Multi-Primary Mode: Any node in the cluster accepts write transactions. If two nodes modify the same row simultaneously, Group Replication detects the conflict and aborts the later transaction!
Code Implementation Example
json
{
"replicationTechnology": "MySQL Group Replication",
"mode": "Multi-Primary",
"consensusProtocol": "Paxos",
"conflictDetection": "Automatic Certify Phase Abort"
}💡MySQL Group Replication multi-primary configuration payload.
🎯 Interview Key Takeaway
Use MySQL Group Replication for high-availability multi-master database clusters with automated fault detection.
#MySQL#Group Replication#Multi-Primary#High Availability#Intermediate
Back to all SQL & MySQL Questions→