Database Migration Service lets you migrate data to a Cloud SQL destination instance,
and then set up cascading read replicas for that instance.
[Cascading read replicas](https://docs.cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external.md.txt#set_up_a_cascading_replica) let you create a read replica under a Cloud SQL read replica in the same or different region before promoting your instance to primary. You can add up to four levels of cascading read replicas, including the primary instance.

<br />

Cascading read replicas in Cloud SQL for MySQL are supported only for
[global transaction identifier (GTID)-based replication](https://dev.mysql.com/doc/mysql-replication-excerpt/8.0/en/replication-gtids-concepts.html).
If you want to use cascading read replicas in your migration,
set `GTID_MODE` to `ON` on your source instance.

## Set up cascading read replicas

To migrate your data to a Cloud SQL destination that is using cascading read
replicas:

1. Perform the standard migration process, but don't promote the migration job
   when it reaches the CDC phase. For more information, see
   [Get started with homogeneous MySQL migrations](https://docs.cloud.google.com/database-migration/docs/mysql/get-started-with-mysql-migrations.md.txt).

2. Once in the CDC phase, you can set up your cascading read replica. For
   information about how to create cascading read replicas for a Cloud SQL destination
   instance, see
   [Set up a cascading replica](https://docs.cloud.google.com/sql/docs/mysql/replication/configure-replication-from-external.md.txt#set_up_a_cascading_replica).

3. You can promote your Cloud SQL replica to primary instance using Database Migration Service.
   For information about promoting a destination instance, see
   [Promote a migration](https://docs.cloud.google.com/database-migration/docs/mysql/promote-migration.md.txt).

When you promote the Cloud SQL replica to a primary instance, the replica's
cascading replica hierarchy is retained.