Help Center/ Relational Database Service/ Best Practices/ RDS for MySQL/ Migrating MySQL Databases from Other Clouds to RDS for MySQL/ Configuring a MySQL Instance on Another Cloud
Updated on 2024-09-06 GMT+08:00
View PDF
Share

Configuring a MySQL Instance on Another Cloud

Prerequisites

  • You have purchased a MySQL instance from another cloud vendor platform.
  • Your account has the migration permissions listed in Permission Requirements.

Permission Requirements

Table 1 lists the permissions required for migrating data from a MySQL instance on another cloud to RDS for MySQL using DRS. For details about the permissions, see Which MySQL Permissions Are Required for DRS?

Table 1 Migration permissions

Database

Full Migration Permission

Full+Incremental Migration Permission

Source database (MySQL)

SELECT, SHOW VIEW, and EVENT

SELECT, SHOW VIEW, EVENT, LOCK TABLES, REPLICATION SLAVE, and REPLICATION CLIENT

Network Configuration

You need to enable public accessibility for the source database.

Whitelist Settings

The EIP of the DRS replication instance must be on the whitelist of the source database for the connectivity between the DRS replication instance and the source database. To obtain the EIP of the DRS replication instance, see 3 in Creating a DRS Migration Task. This method of configuring a whitelist varies depending on the cloud database vendors. For details, see their official documents.

Parent Topic: Migrating MySQL Databases from Other Clouds to RDS for MySQL