AWS RDS Connection Pooling through RDS PROXY

RDS Proxy is a great way to enable connection pooling on RDS database and improve application connectivity. This is MUST know feature when it comes to connection management on RDS.

Brief Steps-

1. Create RDS MySQL database
2. Launch EC2 instance as a client for database
3. Install required packages and MySQL client on EC2 instance
4. Modify RDS_SG to accept connection on 3306 port from EC2_SG
5. Once RDS DB is available, try connecting from EC2 server
6. Create secret in Secrets Manager
7. Create IAM policy and role for Proxy to access secret
8. Create RDS Proxy
9. Connect through RDS Proxy from EC2 instance
10. CleanUP

Reference -
https://aws.amazon.com/getting-starte...

~-~~-~~~-~~-~
Please watch: "Integrate Amazon Bedrock Foundation Models with Lambda function @AWSLearn #ai #aws #awsbedrock"
   • Integrate Amazon Bedrock Foundation M...  
~-~~-~~~-~~-~