API Gateway: Replicate MySQL Error

Products

• CA API Gateway
• API SECURITY
• STARTER PACK-7

Issue/Introduction

In our Production environment, we saw this error after running this command:

mysql -e "SHOW SLAVE STATUS\G"

Master_SSL_Verify_Server_Cert: No

                Last_IO_Errno: 1236

                Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'

Does this mean if any policy changes are made on the primary node, those new policy changes will not sync with the secondary node?   

 

Environment

API Gateway 9.3+

Resolution

That is correct. Replication needs to be rebuilt on the node that is throwing the error.

The replication bin-log could be missing or has been purged. 

REF:  https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api-management/api-gateway/10-1/install-configure-upgrade/configure-a-gateway-cluster/configuring-cluster-database-replication/restart-replication.html