Your company’s rapidly growing ecommerce application uses Cloud SQL for MySQL. Performance issues are surfacing during peak traffic periods. You need to ensure that the database can handle the load while minimizing downtime. What should you do?
A.
Use read replicas for query offloading, configure automatic failover, and test failover procedures regularly.
B.
Vertically scale the primary instance by significantly increasing compute resources, such as vCPUs and memory.
C.
Increase storage size on the existing instance and implement client-side caching for frequently accessed data.
D.
Migrate to a Cloud SQL for PostgreSQL database for better performance during high load.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sai_Vignesh
1 week, 1 day ago