QuestionQ86

VerifiedDesign scalable and highly available cloud database solutions

You manage two separate applications: Order Management and Sales Reporting. Both applications use the same Cloud SQL for MySQL database. The Order Management application reads from and writes to the database 24/7, while the Sales Reporting application is read-only. Both applications require the most current data. You must ensure that the Sales Reporting application does not affect the performance of the Order Management application. What should you do?

Explanation

A Cloud SQL read replica is a read-only copy that receives changes from the primary in almost real time. Routing Sales Reporting read and analytics traffic to that replica offloads those queries from the primary instance, protecting the continuous read/write workload of Order Management.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!