Which solution meets these requirements?
Deploy RDS read replicas to process the business reporting queries.
Scale out the DB instance horizontally by placing it behind an Elastic Load Balancer.
Scale up the DB instance to a larger instance type to handle write operations and queries.
Deploy the DB instance in multiple Availability Zones to process the business reporting queries.
Explanations:
Deploying RDS read replicas allows the company to offload read queries from the primary database instance, ensuring that business reporting queries do not interfere with write operations. This improves overall performance and availability for both read and write operations.
Placing the DB instance behind an Elastic Load Balancer does not address the issue of separating read and write operations. ELBs are primarily used for distributing incoming traffic across multiple instances, but they do not provide read scaling capabilities for a single RDS instance.
Scaling up the DB instance to a larger instance type may improve performance but does not isolate read queries from write operations. It can still lead to contention and performance degradation for write operations during heavy read workloads.
Deploying the DB instance in multiple Availability Zones provides high availability and failover capabilities but does not help with the problem of isolating read workloads from write operations. This solution would not resolve the performance issues related to business reporting queries impacting the production DB instance.
If I’m not mistaken, the answer is:
Deploy RDS read replicas to process the business reporting queries.