Reinitialize replication on API Gateway failing not copying all tables

Products

• CA API Gateway

Issue/Introduction

Reinitialize replication failing to copy all tables. Finding it is stopping on copying to the secondary at tables:

server_module_file_data

Environment

CA API Gateway: 10.x, 11.x

Resolution

Server module file may contain large amounts of data depending on there server_modules installed via policy manager.

As such it may be required to increase the mysql max packet size.

 

1) vi OR nano  /etc/my.cnf

file on both nodes

2) Add config of 100m to 300M or more size mary vary based on data.

max_allowed_packet=100M

3) And restart each node as mysql service

# service mysql restart 

or 

# systemctl mysqld restart