Figure HA-11 · Database tier
MySQL high availability
InnoDB Cluster elects a primary; MySQL Router follows it
rConfig
Active node connection
Connects after failover
Replication
Heartbeat and monitor
01 · CLIENT
rConfig pair
MySQL Router runs on each node
02 · CLUSTER
InnoDB Cluster
Three members, one primary
03 · MANAGEMENT
MySQL Shell
Setup and changes
Node A · rConfig V8
ACTIVE
MySQL Router · 127.0.0.1:6446
Node B · rConfig V8
PASSIVE
MySQL Router · 127.0.0.1:6446
mysql1
PRIMARY
MySQL 8
mysql2
SECONDARY
MySQL 8
mysql3
SECONDARY
MySQL 8
Group Replication · single-primary
MySQL Shell · builds and manages the cluster
Or: primary/replica
primary
MySQL
VIP 192.0.2.30
moved by Orchestrator hooks
replica
MySQL
Orchestrator
watches both, runs failover