ApsaraDB for ClickHouse:Data Migration And Synchronization

Scenario

Data source

References

Synchronize data from Message Queue for Apache Kafka to ApsaraDB for ClickHouse

Kafka

Synchronize data from an ApsaraMQ for Kafka instance

Import data from Apache Flink

Flink

• Use a JDBC connector to write data to an ApsaraDB for ClickHouse cluster

• Use SQL statements to write Flink data to an ApsaraDB for ClickHouse cluster

Import or synchronize data from Big Data services

DataWorks

Use DataWorks to synchronize data

MaxCompute

• Use an external table to import data from MaxCompute to ApsaraDB for ClickHouse (V 19.15.2.2)

• Use an external table to import data from MaxCompute to ApsaraDB for ClickHouse (V20.3 or later)

Import or synchronize data from an ApsaraDB RDS for MySQL instance

RDS MySQL

• Import data from ApsaraDB RDS for MySQL

• Synchronize data from an ApsaraDB RDS for MySQL instance to an ApsaraDB for ClickHouse cluster

Synchronize data from Log Service

SLS

Synchronize data from Log Service

Import data from Object Storage Service (OSS)

OSS

Import data from OSS

Access OSS data

OSS

Access data in OSS

Migrate table data from a self-managed ClickHouse cluster to an ApsaraDB for ClickHouse cluster

Self-managed ClickHouse

Migrate table data from a self-managed ClickHouse cluster to an ApsaraDB for ClickHouse cluster

Migrate data between ApsaraDB for ClickHouse instances

ApsaraDB for ClickHouse

Migrate data between ApsaraDB for ClickHouse Community-compatible Edition clusters

Import local data

Local data

Use clickhouse-client to import data

Use a Spark program to import data