How to Migrate DigitalOcean Managed Databases for MySQL to Vultr Managed Databases for MySQL

Migrating MySQL databases from one host to another allows you to scale existing databases integrate multiple applications. Vultr Managed Databases for MySQL offer a fully-managed cost effective relational database solution and automate most aspects of database administration. Migrating from Digital Ocean Managed Databases for MySQL to Vultr Managed Databases for MySQL enables you to transfer existing databases with minimal downtime and connect with popular client applications.

Follow this guide to migrate DigitalOcean Managed Databases for MySQL to Vultr Managed Databases for MySQL.

Prerequisites

Before you begin, you need to:

• Have an existing DigitalOcean Managed Databases for MySQL subscription to migrate.
• Provision a Vultr Managed Databases for MySQL cluster with the same size or greater than your DigitalOcean Managed Databases for MySQL.
• Install MySQL Client or MySQL Workbench on your local workstation.

Back Up the DigitalOcean Managed Databases for MySQL Cluster

Backing up your source DigitalOcean Managed Databases for MySQL enables you to recover your databases in case of any data corruption or migration failures. Follow the steps below to back up your source DigitalOcean Managed Databases for MySQL cluster using the MySQL client tool on your workstation.

1. Log in to your DigitalOcean account.

2. Navigate to Databases and click your target MySQL cluster to open its management page.

3. Verify the access credentials in the Connection Details section.

   

4. Use the mysqldump to export all databases in your source DigitalOcean Managed Databases cluster into a single migratetovultr.sql file.

   console Copy

   $ mysqldump --host=do-hostname --port=25060 --user=doadmin --password=example-password --all-databases > migratetovultr.sql
   

   The above command exports all databases in your source MySQL cluster to a single migratetovultr.sql file, allowing you to keep a backup of all databases before migrating to a new cluster.

5. Use the following command to back up specific databases in your cluster. Replace exampledb and exampledb2 with your actual target databases.

   console Copy

   $ mysqldump --host=do-hostname --port=25060 --user=doadmin --password=example-password --databases exampledb exampledb2 --single-transaction --set-gtid-purged=OFF > migratetovultr-db.sql
   

Migrate the Source DigitalOcean Managed Databases for MySQL to Vultr Managed Databases for MySQL

You can migrate your existing DigitalOcean Managed Databases for MySQL to Vultr Managed Databases for MySQL using live replication or backup and restore methods.

1. Log in to the Vultr Customer Portal.

2. Click Products and select Databases.

3. Click your target Vultr Managed Databases for MySQL to open its management page.

4. Verify the access credentials within the Connection Details section to use when migrating to the Vultr Managed Databases for MySQL cluster.

   

Follow the steps below to migrate your source DigitalOcean Managed Databases for MySQL using the Vultr Customer Portal or MySQL Workbench.

Test the Vultr Managed Databases for MySQL

Follow the steps below to test the destination Vultr Managed Databases for MySQL when the migration is successful.

1. Log in to your Vultr Managed Databases for MySQL.

   console Copy

   $ mysql --host=vultr-hostname --port=16751 --user=example-user --password=example-password
   

2. List all available databases.

   sql Copy

   mysql> SHOW DATABASES;
   

   Verify that all migrated databases are available in your output, similar to the one below.

   +--------------------+
   | Database           |
   +--------------------+
   | defaultdb          |
   | information_schema |
   | mysql              |
   | exampledb          |
   | performance_schema |
   | sys                |
   +--------------------+

3. Switch to a migrated database such as exampledb.

   sql Copy

   mysql> USE exampledb;
   

4. List all tables in the database.

   sql Copy

   mysql> SHOW TABLES;
   

   Your output should be similar to the one below.

   +---------------------+
   | Tables_in_exampledb |
   +---------------------+
   | example_table       |
   +---------------------+

5. Verify that the table data matches your source database.

   sql Copy

   mysql> SELECT * FROM example_table;
   

   Your output should be similar to the one below.

   +----+---------+-----+---------------------+
   | id | name    | age | created_at          |
   +----+---------+-----+---------------------+
   |  1 | Alice   |  25 | 2025-02-11 08:22:27 |
   |  2 | Bob     |  30 | 2025-02-11 08:22:27 |
   |  3 | Charlie |  28 | 2025-02-11 08:22:27 |
   +----+---------+-----+---------------------+

6. Exit the MySQL console.

   sql Copy

   mysql> EXIT;
   

Cutover to Vultr Managed Databases for MySQL

After verifying that the migration is successful, follow the recommendations below to cutover to Vultr Managed Databases for MySQL.

1. Update your application's database connection settings to point to the Vultr Managed Database.
2. Restart your application and monitor it for connection errors or database performance issues after the cutover.
3. Verify that all data in your source DigitalOcean Managed Databases for MySQL matches your destination Vultr Managed Databases for MySQL, and decommission the database cluster to avoid any additional charges.

Conclusion

You have migrated from DigitalOcean Managed Databases for MySQL to Vultr Managed Databases for MySQL. You can use multiple migration methods to transfer databases to your destination Vultr Managed Databases for MySQL cluster and cutover your existing applications when ready. Vultr Managed Databases for MySQL are scalable and support additional features you can integrate to improve your database performance. Visit the Vultr Managed Databases for MySQL documentation for more information.