MySQL Group Replication
summary
MySQL Group Replication (GA in 5.7.17) is a plugin that implements multi‑master, update‑anywhere replication with in‑memory certification DB on each server for conflict detection, automatic state transfer from a donor for distributed recovery, and a built‑in communication engine so no external multicast is required. Default is single‑primary with automatic primary election (multi‑primary optional). Current practical limits: up to 9 members, requires InnoDB with primary keys, GTIDs and binary logging, and forbids cascading FKs, savepoints, serializable isolation and some event/trigger cases.
AI-written summary · about
chapters (7)
- 0:00Introduction to group replication
- 1:07Conflict detection mechanisms
- 2:56Automated recovery and membership
- 5:35Operational features and settings
- 9:10Multi-master vs single-primary
- 11:07System requirements and constraints
- 15:26Q&A and advanced architecture
related talks
49mMySQL Replication — Advanced Features
51mReplication latest features: the community sceptic roundup
53mMySQL replication setup, benefits, limitations
35mMySQL HA, Recovery and Load Balancing
43mHow MySQL Replication Works
29mEverything You Ever Wanted to Know About MariaDB Replication but Were Afraid to Ask
50mMySQL/MariaDB Parallel Replication: inventory, use cases and limitations
49mMySQL GTID Implementation, Maintenance, and Best Practices - The Short Version