This topic describes how the leader-follower topology works in VMware SQL with MySQL for Tanzu Application Service and contains information to help you decide whether to enable or use leader-follower.
The leader-follower topology increases the availability of a MySQL database by deploying two MySQL VMs in two separate availability zones (AZs). When a developer creates a leader-follower service instance, the on-demand broker deploys a leader VM in one AZ, and a follower VM in another AZ.
A leader-follower topology enables operators to initiate a failover and send app traffic to the follower if the leader fails. This ensures that the app bound to the MySQL database continues to function normally.
The follower VM is only for increasing availability and is not exposed to developers to increase read throughput. Developers who want increased read throughput can configure
workload profiles. For more information, see About Workload Types.
The following diagram shows a leader-follower service instance in two availability zones (AZs):
In the previous diagram, the leader and follower nodes are each shown in their own AZ, separated by a dotted line.
An app sends traffic to the leader node. A two way arrow connects the leader to the follower indicating that any data that is written to the leader is replicated to the follower. The leader and the follower each have their own disk.
VMware SQL with MySQL for TAS focuses on data consistency rather than availability. Therefore, it does not trigger failover automatically, but relies on operators to trigger a failover. When an operator triggers a failover, the follower is promoted to the leader and app traffic is sent to the follower.
For more information, see Triggering a Leader-Follower Failover.
By default, any data that is written to the leader is asynchronously replicated to the follower. VMware SQL with MySQL for TAS also supports synchronous replication (“sync”).
In sync replication, data does not get committed to the leader node until the follower acknowledges the commit and can replicate it. By default, the timeout for sync replication is set to approximately 292 million years. This means that the leader always waits for the follower to confirm receipt of the transaction.
For information about enabling sync replication, see Synchronous Replication for Leader-Follower.
VMware SQL with MySQL for TAS automates orchestrating the standard lifecycle of creating, updating, and deleting leader-follower service instances.
In addition, VMware SQL with MySQL for TAS provides three leader-follower errands. An operator can use them to control the lifecycle of a leader-follower service instance and manually intervene, when necessary, without being an expert at MySQL.
For more information, see configure-leader-follower in Running Errands.
Leader-follower instances have additional infrastructure requirements to singleton instances, as described in the following section.
When calculating IaaS usage, you must take into account that each leader-follower instance requires two VMs. Therefore, the resources used for a leader-follower-enabled plan must be doubled. For more information, see Resource Usage Planning for On-Demand Plans.
To minimize impact of an availability zone (AZ) outage and to remove single points of failure, VMware recommends that you provision three AZs if using leader-follower deployments. With three AZs, the MySQL VMs are deployed to two AZs and the broker is deployed to a third.
For more information, see Availability Using Multiple AZs in VMware SQL with MySQL for Tanzu Application Service Recommended Usage and Limitations.
In addition to the standard networking rules needed for VMware SQL with MySQL for TAS, the operator must ensure leader-follower-specific network rules are also set up as follows:
For information about the standard networking rules, see Required Networking Rules for On-Demand Services.