In this lab, you will create a cost-effective and resilient migration setup to transfer a MySQL database from an on-premises environment to a managed Cloud SQL instance. You will use Google's Database Migration Service (DMS) to ensure minimal downtime during the cutover process. Additionally, you'll explore the use of high availability features of Cloud SQL and strategies for managing database scaling needs. The lab will also guide you on setting up a reverse replication channel back to an on-premises MySQL instance, crucial for contingency planning. This real-world use case helps prepare you to address scenarios of database migration with the added complexity of syncing changes, all while operating within budget constraints.
You work for a retail company planning to migrate their critical inventory database from an on-premises server to Google Cloud to improve resilience and reduce maintenance overhead. The database must remain available with less than 5 minutes of downtime during migration. Post-migration, the system should support 2,000 concurrent read transactions and seamlessly integrate an order management application that remains on-premises. A fallback plan with reverse replication to the on-premises server is required for continuity.
