CA API Gateway saturating otk_db database with connections

Products

• CA API Gateway

Issue/Introduction

4 CA API Gateway appliances pointing to a single MySQL otk_db Database. The Database is being flooded with connections (18000+) and it makes the API processing not work.

We need to understand how to restore processing of APIs request

 

Environment

Release : 10.0

Component : API GATEWAY

Cause

Over configured the JDBC properties in Azure mysql setup causing the 4 gateway to open close to 5k connections each to mysql - resulting in exceeding connection to mysql 

Resolution

Changes recommended