In the Appliance form factor, a series of pre-built scripts are you to easily setup MySQL replication in a Master-Master mode for clustered multi-nodes Gateway.
However for Software form factor Gateway, scripts are not included and this can be a useful reading and good exercise to get familiar with MySQL replication setup. Recommended to be tested in a low environment.
The following example is based on CA API Gateway 9.3 and MySQL 5.5.x
Before to start:
• Verify Gateway (Software) pre-requisites https://docops.ca.com/ca-api-gateway/9-3/en/install-configure-upgrade/configure-the-software-gateway/install-the-gateway-software
• Ensure both nodes are capable to resolve their own hostnames
API Gateway 9.x
1. Install MySQL
GTID-based replication was introduced in MySQL 5.6.5 but it isn't supported by the Layer7 API Gateway.