API Gateway: Replicate MySQL Error

book

Article ID: 185772

calendar_today

Updated On:

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.

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