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

Products

• CA API Gateway

Issue/Introduction

There is an API gateway that gets stuck because max connections were reached. Looking into further, the following message is 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

API Gateway 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. 

Alternatively, you can upgrade the version of MySQL with the current Monthly Platform Patch so that it is dynamic.

Blog: Dynamic InnoDB Redo Log in MySQL 8.0