31/10/2024
🧩 Sharing a summary of what I have learnt today.
🗓️ Date: 01-11-24
❓ About: RDS Proxy
Summary:
1. Manages RDS/Aurora DB connection pools.
2. Establish, maintain and terminate connections.
3. Can build a target groups with multiple DB instances and let RDS proxy to maintain load and balances across the instances.
4. Reduces DB instance workload by removing overheads.
5. IAM authentication can be applied, what increases security.
6. RDS proxy prevents DB to be publicly accessible. Must access from VPC.
Use Cases:
1. If you have a large fleet of applications that are using single one or fewer DB instances, then it will be hard to maintain DB connection pools. Sometimes we may have faced such problems while setting up DB connection pools from application end. Though we can manage it from application but it is always at some extent, there can be fail-over. So, to maintain more reliability and less fail-over we set a Proxy in middle. It reduces about 66% fail-over.
2. If we are using a good amount of lambda to manage our business logic and other application staff, then it will be a great concern to maintain and to keep in limit the number of DB connections. So, in such case we can setup a Proxy to protect our DB from overwhelming number of connections and maintain a fewer connection to DB instance from proxy.
hashtag hashtag hashtag
Send a message to learn more