In this two-part blog series, I wanted to cover some failover
scenarios with Group Replication. In part one, I will discuss an
interesting behavior and performance degradation I discovered
while writing these posts. In part two, I will show several
failover scenarios and demonstrate how Group Replication handles
each situation.
The test environment is very basic, a three-node Group
Replication (mysql1,mysql2,myslq3) on MySQL 8.0.19 with default
settings. mysql2
is the Primary
node.
In this scenario, I was testing a partial network failure when a
node gets separated from the primary, but other nodes still can
see it.
You would think mysql3
is going to lose quorum and
exit the cluster, but no. Inside the cluster, all the nodes are
in constant communication with each other, not just …
[Read more]