Answer-first summary for fast verification
Answer: Use many smaller Cloud SQL instances.
Given the scenario where the application follows a microservices architecture and is experiencing performance issues with a single large Cloud SQL instance, despite normal CPU utilization, the Google-recommended practice to resolve and prevent these performance issues without major refactoring is to use many smaller Cloud SQL instances. This approach aligns with the microservices architecture by allowing each service to have its own database instance, which can improve performance and scalability. Option A suggests using Cloud Spanner, which, while scalable, would require significant refactoring. Option B suggests increasing the number of CPUs, but since CPU utilization is normal, this may not address the underlying issue. Option C suggests increasing storage size, which is unrelated to performance issues not caused by storage constraints. Therefore, the correct answer is D.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can you address and prevent performance issues in your growing microservices-based application that uses a single large Cloud SQL instance, where CPU utilization appears normal in Cloud Monitoring, while adhering to Google-recommended practices and minimizing major refactoring?
A
Use Cloud Spanner instead of Cloud SQL.
B
Increase the number of CPUs for your instance.
C
Increase the storage size for the instance.
D
Use many smaller Cloud SQL instances.
No comments yet.