redo log sizing and replication for mysql 8.0.29 and below on ca api gateway.

Products

• CA API Gateway

Issue/Introduction

We had a api gateway get stuck and tell us max connections were reached. Looking into further, we found the following message repeating:

2023-06-20T01:54:47.762742Z 0 [ERROR] [MY-013059] [InnoDB] Out of space in the redo log. Checkpoint LSN: 10392668685865. Consider increasing innodb_redo_log_capacity.

Environment

Release : 10.1

Resolution

Depending on the available space (and size of your /var/lib/mysql mount) for high usage enviroments (OTK/High Audits) an increase of the redo log to 4g may be required. 

Or upgrade the version of mysql with the current Monthly Platform Patch so that it is dynamic,

https://dev.mysql.com/blog-archive/dynamic-innodb-redo-log-in-mysql-80/#:~:text=The%20default%20is%20100MB.,new%20dedicated%20folder%3A%20%23innodb_redo%20.