Help Center/ GaussDB(for MySQL)/ Best Practices/ From Other Cloud MySQL to GaussDB(for MySQL)/ Configuring a MySQL Instance on Other Clouds
Updated on 2023-10-08 GMT+08:00
View PDF
Share

Configuring a MySQL Instance on Other Clouds

Prerequisites

  • You have purchased a MySQL instance on other platforms.
  • The MySQL account has the migration permissions listed in Permission Requirements.

Permission Requirements

To migrate data from a MySQL database on other clouds to a GaussDB(for MySQL) instance, the following permissions are required.

Table 1 Required permissions

Database

Full Migration Permission

Full+Incremental Migration Permission

Source DB (MySQL)

SELECT, SHOW VIEW, and EVENT

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

For details about MySQL authorization operations, see operation guide.

Network Configuration

Enable public accessibility for the source database. The method for enabling public accessibility depends on the cloud database vendor. For details, see the official documents of the corresponding cloud database vendor.