ApsaraDB for ClickHouse:Overview of data migration and synchronization solutions

Scenario

Data source

References

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

Kafka

Synchronize data from Message Queue for Apache Kafka

Import data from Apache Flink

Flink

• Use 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

Synchronize data from DataWorks

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 an ApsaraDB RDS for MySQL instance

• 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 clusters

Import local data

Local data

Use clickhouse-client to import data

Use a Spark program to import data