QuestionQ47

VerifiedMigrate data solutions

You plan to migrate an on-premises MySQL database to Cloud SQL. The on-premises database currently has 16 cores and 64 GB of RAM and averages 75% CPU utilization to support an application with over 100.000 tables.

You need to specify the most cost-effective machine size required when migrating to Cloud SQL for MySQL. What should you do?

Explanation

Cloud SQL for MySQL has a default limit of 50,000 tables. An instance can support up to 500,000 tables only if it has at least 32 cores and 200 GB of memory. A 32-core, 256-GB configuration meets those requirements and is the least costly listed configuration that does so.

Learn more

Community Discussion

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