RDS connections issue

Question

1. I'm encountering an issue with RDS connections where they're not being properly deleted after disconnection. This results in a rapid increase in the number of connections, even though they're not actively in use. Is there a solution to immediately delete the connection after disconnecting through Python code?
2. Can MySQL community engine support the usage of RDS proxy?

Answer

If you are getting a build-up of connections on your RDS instance, it happens because your client library is not closing the socket to the RDS instance. You should review your code and ensure that:

1. It closes sockets when you are done talking to the database
2. Always re-use sockets (ie., employ connection pooling) to the database for subsequent queries.

If you cannot fix this behavior in your client software - then you can use the AWS with RDS MySQL. You can however not use this with a stand-alone MySQL server on EC2.

Ref: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy.html

Answer

1)
Are you using mysql-connector-python?
If so, do you close both the cursor and the connection after the process is finished? (Or do you use "with" to open them?)

2)
By MySQL community engine, do you mean RDS for MySQL or MySQL installed on EC2?

RDS Proxy supports RDS for MySQL.
However, it does not support MySQL installed on EC2.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy.html#rds-proxy.limitations-my

RDS connections issue

Contenus pertinents