Getting started with Data Transfer
With Data Transfer, you can transfer data from a third-party source cluster to a target cluster without interrupting user service. In this guide, you will learn how to transfer a third-party MySQL® cluster to Managed Service for MySQL®. Replication is performed by configuring endpoints and the transfer between them.
For the full list of endpoints and possible transfers between them, see Transfers available in Data Transfer.
You will create resources in the management console in your folder, for which you will need the editor role. Some resources are paid, so make sure your billing account is active.
Configure the source and the target
-
Create a target Managed Service for MySQL® cluster of any suitable configuration. In this case, the following applies:
-
The MySQL® version must be the same as or higher than in the source cluster.
Data transfer with a major MySQL® version upgrade is possible but not guaranteed. For more information, see this MySQL® guide.
Migration to an earlier MySQL® version is not supported.
-
SQL mode must be the same as in the source cluster.
-
Creating an endpoint for the source
-
In the management console, navigate to the relevant folder.
-
Navigate to Data Transfer.
-
In the left-hand panel, select Endpoints.
-
Click Create endpoint.
-
In the Direction field, select
Source. -
Name the endpoint.
-
In the Database type field, select
MySQL®. -
Specify endpoint parameters in the corresponding settings section.
For more on available parameters, see Transferring data from a MySQL® source endpoint.
-
Click Create.
Creating an endpoint for the target
-
In the management console, navigate to the relevant folder.
-
Navigate to Data Transfer.
-
In the left-hand panel, select Endpoints.
-
Click Create endpoint.
-
In the Direction field, select
Target. -
Name the endpoint.
-
In the Database type field, select
MySQL®. -
Specify endpoint parameters in the corresponding settings section.
For more on available parameters, see Transferring data to a MySQL® target endpoint.
-
Click Create.
Create a transfer
-
In the management console, navigate to the relevant folder.
-
Navigate to Data Transfer.
-
In the left-hand panel, select Transfers.
-
Click Create transfer.
-
Enter a name for the transfer.
-
(Optional) Add a transfer description.
-
Select the new source and target endpoints.
-
Select the type of transfer:
-
Snapshot: To create a full copy of the data without receiving further updates from the source. You can also use this type to replicate constantly changing tables.
If you need to create a full copy of the data at specific intervals, enable Periodic snapshot.
-
Replication: To continuously receive data updates from the source and apply them to the target (without creating a full copy of the source data).
-
Snapshot and increment: To create a full copy of the source data and keep it up-to-date.
-
-
Click Create.
For more information, see Creating a transfer.
Activate the transfer
- In the management console, navigate to the relevant folder.
- Navigate to Data Transfer.
- In the left-hand panel, select Transfers.
- Click next to the transfer name and select Activate.
The data transfer process will begin.
Complete your data transfer
-
Wait for the transfer status to change to Replicating.
-
Switch the source cluster to read-only mode and transfer the workload over to the target cluster.
-
Monitor the transfer status on the monitoring page.
When the Maximum data transfer delay chart (data lag in seconds) drops to zero, all the changes in the source cluster that took place after the data copying ended will be transferred to the target cluster. From that point on, you will be able to work with the transferred data.
What's next
- Read about the service concepts.
- Learn more about preparing databases for the service and setting up transfers.
- Learn which roles exist in Data Transfer.
- Check out our tutorials on using Data Transfer.