Free Preparation Discussions
MENU
Amazon Exam SOA-C02 Topic 6 Question 119 Discussion
Topic #: 6
[Cost and Performance Optimization]
A company has an ecommerce application. The application runs on Amazon EC2 instances that are in an Auto Scaling group. The company runs a backend PostgreSQL database on Amazon RDS. As the number of EC2 instances increases during times of high application usage, the database's CPU utilization increases. At the same time, the database's available memory significantly decreases. A SysOps administrator must reduce the overhead of the new database connections from the Auto Scaling group in a highly available manner.
Which solution will meet this requirement?
Amazon RDS Proxy is a fully managed, highly available database proxy for Amazon RDS that helps improve the scalability, availability, and security of database applications. It allows applications to pool and share database connections, reducing the overhead associated with opening and closing connections, which can be particularly beneficial in scenarios with fluctuating workloads, such as those managed by Auto Scaling groups.
By implementing RDS Proxy, you can:
Reduce CPU and Memory Overhead:
By managing a pool of connections, RDS Proxy reduces the number of active connections to the database, thereby decreasing the CPU and memory usage on the RDS instance.
Improve Application Scalability:
RDS Proxy can handle a large number of simultaneous connections, making it easier to scale applications without overloading the database.
Enhance Availability:
In the event of a database failover, RDS Proxy can automatically connect to a standby database instance, preserving application connections and reducing failover times.
Therefore, creating an RDS Proxy and configuring it to connect to the existing PostgreSQL database is the most effective solution to meet the company's requirements.
Rolande
2 hours ago