Migrating a database from a third-party MySQL® cluster to a Yandex Managed Service for MySQL® cluster
You can migrate data from a third-party source cluster to a Managed Service for MySQL® target cluster using the following two methods:
-
Migrating data via 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.
-
Migrating data using a logical dump (backup and restore).
A logical dump is a file containing a sequence of commands allowing you to restore a database to its saved state. To ensure the logical dump is complete, switch the source cluster to
read-only
mode before creating the dump.Use this method only if data migration via Data Transfer is impossible.