Sample Header Ad - 728x90

MySQL Group Replication consistency EVENTUAL vs BEFORE_ON_PRIMARY_FAILOVER

1 vote
1 answer
428 views
As far as I understand, BEFORE_ON_PRIMARY_FAILOVER is exactly behaving like EVENTUAL in normal scenarios until a failover happened, which the former will block all new transactions until the new primary node has applied its backlog while the latter allows transactions to be run immediately. I have tried both options in the lab environment. When the replication lag is relatively high, it takes a very long time for the new primary to apply backlog and open to new transactions. This significantly affects HA, render the auto-failover feature of Group Replication almost meaningless. So my question is, is that really beneficial to use BEFORE_ON_PRIMARY_FAILOVER instead of EVENTUAL? Is that really a "safer" option? Some info about my environment in case that matters: MySQL 8.0.25, installed using TAR ball format. RHEL: 8.0
Asked by Matthew Kwong (113 rep)
Jun 28, 2021, 02:55 AM
Last activity: Jun 28, 2021, 03:34 AM