Migration Management

Available in VPC

Migration management allows you to create migration tasks and automate tasks required for migration by stage. Additionally, you can check the status of migration tasks and restart, stop, complete, and delete a task as needed.
Database migration proceeds through the steps of backup, recovery, and data synchronization.

• Backup (Export): data backup from source DB
• Recovery (Import): data recovery to target DB
• Data synchronization (Replication): data synchronization of the source DB and the target DB

Prepare for migration

Please complete the following before creating and performing a migration task.

• Set source DB and target DB connection (Refer to source DB and target DB connection settings)
• Create the source DB endpoint (See Create endpoint)
• Check whether the target DB is in operation
• Create an account with the same ID and connection host to the target DB, if you have a procedure Definer account being used on the source DB (See Manage DB user)
• If you change the source DB config, apply such changes on the target DB (See Manage DB config)
• Delete the database on the target DB if the target DB has the same database as the source DB

Create migration task

You can migrate from the source DB data to the target DB by creating a migration task.

To create a migration task, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Database > Database migration service, in order.
2. Click the Migration management menu.
3. Click the [Create migration task] button.
4. Enter the following information.
   • Migration task name: enter the name you want
   • Source DB: select the source DB identifier of the source DB endpoint
     • [Endpoint modification]: click this to edit the source DB connection information set in the endpoint (For more information on connection, see Create endpoint)
   • Endpoint URL, DB PORT, DB user: display the source DB information set in the endpoint when selecting the source DB
   • Target DB: select the target DB created in NAVER Cloud Platform
5. Click the [Test connection] button to test the connection between source DB and target DB.
   • DB engine version and GTID MODE information is entered automatically when the test is successful
   • The notification pop-up window is shown when an error occurs
6. Enter the following information.
   • Backup type: automatically input mysqldump
   • Thread limitation: 1 automatic input
7. Click the [Start migration task] button.
   • The button will be activated after the connection test is completed.
8. When the pop-up notification window appears, click the [OK] button.
   • Migration will start.

Check migration task information

To check the created migration task's information, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Database > Database migration service, in order.
2. Click the Migration management menu.
3. Check Task information by viewing the basic information in the task list or clicking the task you want to view.
   • Basic information
     • Task status: current status of the task
       • Ongoing: status of migration in progress
       • Crashes: status of migration being ended abnormally due to an error occurrence
       • Stopped: status of migration being forcibly stopped by the user
       • Completed: status of being completely disconnected from DB, so restarting or going back to the previous status is not available
     • Execution stage: display the current task stage This is displayed only when the task status is ongoing
       • Exporting: data backup on the source DB is in operation
       • Importing: data is being recovered to the target DB
       • Replication: data synchronization of the source DB and the target DB is in operation
     • Source DB: source DB identifier set by the user
     • Target DB: target DB name set by the user
     • Start date: time when the migration starts
     • End date: time when the migration is completed is shown
     • Time elapsed: time it took for the migration if migration is completed, and time elapsed from the initial migration to the current if it is in progress
     • Migration size: size of the backup file on the source DB
   • Task information
     • Source DB engine version: source DB's DBMS type and version
     • Target DB engine version: target DB's DBMS type and version
     • Migration start date: time when the migration starts
     • Migration end date: time and date when the migration is completed is shown
     • Migration status: the current status of the task
     • Target DB server name: name of the target DB server
     • Execution stage: if the task status is ongoing, each execution stage (Before running the task, in progress, completion, and error) is shown
       • Exporting: status of data backup on the source DB
       • Importing: status of data recovery to the target DB
       • Replication: status of data synchronization of the source DB and the target DB
       • If the execution stage is Error, click View error to check the error details

Restart migration task

To restart a migration task that ended abnormally or stopped, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Database > Database migration service, in order.
2. Click the Migration management menu.
3. Click the task to restart in the task list and then click the [Restart] button.
4. When the pop-up notification window appears, click the [OK] button.
   • Task status is changed to In progress.

Stop migration task

To stop a migration task in progress, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Database > Database migration service, in order.
2. Click the Migration management menu.
3. Click the task to stop in the task list and then click the [Stop] button.
4. When the pop-up notification window appears, click the [OK] button.
   • Task status is changed to Stopped.

Migration task completed

Finish the data synchronization task with the source DB and change the target DB to the status of being able to be manipulated.

• It is available only if the task status of migration is Ongoing, its execution stage is Replication completed.

To complete the migration task, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Database > Database migration service, in order.
2. Click the Migration management menu.
3. Click the task to end in the task list and then click the [Complete] button.
4. When the pop-up notification window appears, click the [OK] button.

Delete migration task

You can delete the migration task information. However, the information can be deleted only when the task status of migration is crashed, suspended, or completed.

To delete the migration task information, follow these steps:

1. From the NAVER Cloud Platform console, click Services > Database > Database migration service, in order.
2. Click the Migration management menu.
3. Click the task you want to delete information from in the task list and then click the [Delete] button.
4. When the pop-up notification window appears, click the [OK] button.