You need to perform a one-time migration of data from a running Cloud SQL for MySQL instance in the us-central1 region to a new Cloud SQL for MySQL instance in the us-east1 region. You want to…

Question

Options

• ACreate and run a Dataflow job that uses JdbcIO to copy data from one Cloud SQL instance to
• BCreate two Datastream connection profiles, and use them to create a stream from one Cloud SQL
• CCreate a SQL dump file in Cloud Storage using a temporary instance, and then use that file to
• DCreate a CSV file by running the SQL statement SELECT...INTO OUTFILE, copy the file to a

• A
  3% (1)
• B
  10% (3)
• C
  73% (22)
• D
  13% (4)

Explanation

Creating a SQL dump via a temporary Cloud SQL instance (a clone of the source) is the recommended approach because the dump operation is performed against the clone, not the live production instance. This completely isolates the migration workload from the running application. The dump file is stored in Cloud Storage and then used to import into the new us-east1 instance. Using Dataflow with JdbcIO (A) would query the live instance directly, adding load. Datastream (B) is designed for continuous replication, not one-time migrations, and adds unnecessary complexity. SELECT INTO OUTFILE (D) writes directly to the MySQL server's local filesystem and also impacts the running instance.

No community discussion yet for this question.