CA API Gateway - Temporarily Disable Bin Logging in Replicated MySQL DB Cluster
search cancel

CA API Gateway - Temporarily Disable Bin Logging in Replicated MySQL DB Cluster

book

Article ID: 274089

calendar_today

Updated On:

Products

CA API Gateway

Issue/Introduction

If your Gateway MySQL DB Replication has broken and you cannot immediately reinstate it with KB Article https://knowledge.broadcom.com/external/article?articleId=44402 you may have a need to temporarily disable the growth of ssg-bin.log00000x files in your /var/lib/mysql directory   

Environment

Release : Gateway 10.x and 11.x

Resolution

To temporarily disable MySQL Bin Logging in a Replicated MySQL Cluster simply uncomment the following line in your Primary MySQL DB's /etc/my.cnf file 

#disable_log_bin

to

disable_log_bin

Then restart MySQL Service with service mysql restart

In this scenario your MySQL Primary and Secondary Replication may be broken (down) for some time until a maintenance window is established to run the reinstatement of replication as per article: API Gateway: Reinitialize replication in a multi-node cluster

However, by uncommenting #disable_log_bin, there will be no risk of the ssg-bin.log00000x files continuing to grow unchecked and putting the file system at risk:

Please remember to comment this value out again (and restart MySQL) before you reinstate replication.  Again, this is just a temporary way to halt the growth of Bin log files until replication can be addressed.

 

Additional Information