All Products
Search
Document Center

:How do I migrate data of self-managed databases to an ApsaraDB RDS instance?

Last Updated:Oct 26, 2023

Overview

This topic describes how to migrate data of self-managed databases that run different database engines to an ApsaraDB RDS instance.

Description

During migration, service interruptions or transient connections may occur. For more information, see References. The following section describes how to migrate data of self-managed databases that run different database engines to an RDS instance.

MySQL

For more information about how to migrate the data of a self-managed MySQL database to an ApsaraDB RDS for MySQL instance, see Migrate data from a self-managed MySQL database to an ApsaraDB RDS for MySQL instance.

SQL Server

For more information about how to migrate the data of a self-managed SQL Server database to an ApsaraDB RDS for SQL Server instance, see the following topics:

PostgreSQL

For more information about how to migrate the data of a self-managed PostgreSQL database to an ApsaraDB RDS for PostgreSQL instance, see the following topics:

MariaDB

For more information about how to migrate the data of a self-managed MariaDB database to an ApsaraDB RDS for MariaDB instance, see Use mysqldump to migrate data from a self-managed MariaDB database to an ApsaraDB RDS for MariaDB instance.

References

During migration, service interruptions or transient connections may occur. For more information, see Limits. Interruptions or transient disconnections may occur due to the following reasons:

  • RDS Basic Edition does not provide a secondary RDS instance that serves as a hot standby. When you migrate the data of an RDS instance that runs RDS Basic Edition, your database service may become unavailable for half an hour or longer. We recommend that you change the specifications of the RDS instance during off-peak hours to minimize the impact on your business.

  • If you use RDS editions other than RDS Basic Edition, your database service may experience a transient connection that lasts approximately 30 seconds during the migration. This only slightly impacts your workloads. However, we still recommend that you migrate data during off-peak hours or make sure that your application is configured to automatically reconnect to your RDS instance.

  • In most cases, if your RDS instance is equipped with cloud disks and does not run RDS Basic Edition, no transient connections occur when you increase the storage capacity of the RDS instance.

Application scope

  • ApsaraDB RDS for MySQL

  • ApsaraDB RDS for SQL Server

  • ApsaraDB RDS for PostgreSQL

  • ApsaraDB RDS for MariaDB