implementing AWS RDS PostgreSQL Connection Pooling Using Sequelize in Node.js
I've spent hours debugging this and I've searched everywhere and can't find a clear answer... I'm having trouble with I'm optimizing some code but I'm stuck on something that should probably be simple. Quick question that's been bugging me - I am experiencing issues with connection pooling when using Sequelize with an AWS RDS PostgreSQL instance. My application is throwing the behavior `SequelizeConnectionError: Connection terminated due to timeout` after a few requests. I have set up my RDS instance with the default settings but am unsure if this is affecting performance. I've tried increasing the connection limit in my `config.js` file, but it hasn't resolved the question. Here’s the relevant part of my configuration: ```javascript const { Sequelize } = require('sequelize'); const sequelize = new Sequelize('database', 'username', 'password', { host: 'your-rds-endpoint.amazonaws.com', dialect: 'postgres', pool: { max: 10, min: 0, acquire: 30000, idle: 10000, }, }); ``` I've also implemented a retry mechanism in my application, but it seems to only mask the underlying question as connections are still failing intermittently. I suspect it might be related to the `idle` time setting or the maximum number of connections allowed by my RDS instance. Additionally, I checked the AWS RDS metrics and noticed that the `DatabaseConnections` metric is frequently reaching the upper limit, which is set to 100. I am unsure if I need to adjust the parameters of my RDS instance or if there’s a better way to handle pooling with Sequelize. Has anyone faced a similar scenario, and what adjustments can I make to improve the connection handling in this setup? Is there a better approach? This is happening in both development and production on Windows 11. What am I doing wrong? I recently upgraded to Javascript LTS. I'm on Debian using the latest version of Javascript. This is my first time working with Javascript stable. Has anyone else encountered this?