MySQL Replication Groups

TIBCO Cloud™ API Management - Local Edition cluster in untethered mode uses MySQL replication groups.

In the case of one of the zones going down in a multi zone cluster, to achieve high availability, three or more zones are required.

If there are three or more zones, one or more tml-sql pods in each zone are needed to ensure MySQL's availability.

Note: Quorum =.Number of members / 2 + 1

To achieve true high availability, a minimum number of 3 zones is required; two or more tml-sql pods in one zone are better than single tml-sql pod in one zone since loads are distributed among available tml-sql pods.

The following section covers MySQL replication groups, and how to rebuild one for an untethered Kubernetes-based API Management - Local Edition cluster.