Professional-Cloud-Database-Engineer Exam Dumps : Google Cloud Certified - Professional Cloud Database Engineer

Open a support ticket in Google Cloud to prevent any maintenance in that MySQL instance during the month of December.

Use Cloud SQL maintenance settings to prevent any maintenance during the month of December.

Create MySQL read replicas in different zones so that, if any downtime occurs, the read replicas will act as the primary instance during the month of December.

Create a MySQL regional instance so that, if any downtime occurs, the standby instance will act as the primary instance during the month of December.

Use Database Migration Service to migrate all databases to Cloud SQL.

Use Database Migration Service for one-time migrations, and use third-party or partner tools for change data capture (CDC) style migrations.

Use data replication tools and CDC tools to enable migration.

Use a combination of Database Migration Service and partner tools to support the data migration strategy.

Restore the Cloud SQL instance from the automatic backups in region 3.

Restore the Cloud SQL instance from the automatic backups in another zone in region 1.

Check "Lag Bytes" in the monitoring dashboard for the primary instance in the read replica instance. Check the replication status usingpg_catalog.pg_last_wal_receive_lsn(). Then, fail over to region 2 by promoting the read replica instance.

Check your instance operational log for the automatic failover status. Look for time, type, and status of the operations. If the failover operation is successful, no action is necessary. Otherwise, manually perform gcloud sql instances failover .