The CA API Gateway uses MySQL replication to provide database failover and availability should one Gateway appliance or database server become unavailable or degraded. MySQL replication will ensure that a duplicated copy of a database object is maintained in one or more locations. The Gateway uses a master-master implementation in a multi-node environment to ensure that database changes to one host are replicated to the other database host.
MySQL replication is capable of repairing itself if the other database node is unavailable. Replication can repair itself after a node in the cluster experiences a graceful shutdown, MySQL server shutdown, or a network outage. Replication will fail if a data consistency error is experienced. This article will prescribe how to reinitialize replication in a multi-node cluster.
The following data may be visible when running the SHOW SLAVE STATUS query against the local MySQL database:
The following log entries may be present in the Gateway log files:
2380 WARNING "Error accessing host/database
2381 WARNING "Replication failing for host/database