Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How can you migrate an on-premises MySQL database to Cloud SQL for MySQL with minimal downtime while ensuring transaction consistency, given that the on-premises database runs a supported MySQL version and uses the InnoDB storage engine?
A
B
C
D
1 Pause the on-premises applications. 2. Use the mysqldump utility to dump the database content in CSV format. 3. Run gsutil –m to move the dump file to Cloud Storage. 4. Use the Cloud SQL for MySQL import option. 5. After the import operation is complete, re-point the applications to the Cloud SQL for MySQL instance.