Your business is building a new application that will store its entire customer database on a RDS MySQL
database, and will have various applications and users that will query that data for different purposes.
Large analytics jobs on the database are likely to cause other applications to not be able to get the query
results they need to, before time out. Also, as your data grows, these analytics jobs will start to take more time,
increasing the negative effect on the other applications.
How do you solve the contention issues between these different workloads on the same data?
Enable Multi-AZ mode on the RDS instance
Use ElastiCache to offload the analytics job data
Create RDS Read-Replicas for the analytics work
Run the RDS instance on the largest size possible