Synchronize data

AnalyticDB for MySQL supports the following data loading methods:

• You can use Data Transmission Service (DTS) to import data from MySQL or DRDS into AnalyticDB for MySQL. The MySQL data source can be an RDS for MySQL instance, a self-managed database on an ECS instance, a database from another cloud provider, or an on-premises database. For more information, see Synchronize data from RDS for MySQL using DTS.

• You can use Data Integration to import data from ODPS, OSS, MySQL, Oracle, or SQL Server into AnalyticDB for MySQL. For more information, see Migrate data to AnalyticDB for MySQL using Data Integration.

• You can use Kettle to import data from relational databases, NoSQL data sources (such as Hbase), Excel, and Access into AnalyticDB for MySQL. For more information, see Use Kettle to import on-premises data into AnalyticDB for MySQL.

• You can use the Logstash plug-in to write collected data, such as logs, to AnalyticDB for MySQL in real time.

• You can use the AnalyticDB for MySQL client to efficiently write data to the database.

• You can use ADB Uploader to import on-premises data into the database.

• You can use Data Manipulation Language (DML) commands, such as INSERT and DELETE, to load data into AnalyticDB for MySQL.

• If the data already exists in other tables in the database, you can use INSERT SELECT FROM to load the data.