Migrating a database from a third-party MySQL® cluster to a Yandex Managed Service for MySQL® cluster
There are two ways to migrate data from a third-party source cluster to a Managed Service for MySQL® target cluster:
-
Transferring data using Yandex Data Transfer.
This method is easy to configure, does not require the creation of an intermediate VM, and allows you to transfer the entire database without interrupting user service. To use it, allow connections to the source cluster from the internet.
For more information, see Problems addressed by Yandex Data Transfer.
-
Transferring data by creating and restoring a logical dump.
A logical dump is a file with a set of commands running which one by one you can restore the state of a database. To achieve a full logical dump, before you create it, switch the source cluster to
read-only
.Use this method only if, for some reason, it is not possible to migrate data using Data Transfer.