Transfer MySQL to ClickHouse

Fast, streaming database-to-database transfer with parallel processing

Source

MySQL

Native MySQL driver integration

FastTransfer

Streaming Engine

Target

ClickHouse

bulk load

Terminal

FastTransfer.exe `
  --sourceconnectiontype "mysql" `
  --sourceserver "your-source-server" `
  --sourcedatabase "your-source-db" `
  --query "SELECT * FROM your_table" `
  --targetconnectiontype "clickhouse" `
  --targetserver "your-target-server" `
  --targetdatabase "your-target-db" `
  --targettable "your_table" `
  --method "Ntile" `
  --distributekeycolumn "id"  `
  --degree 10

Related Pipelines

SQL Server → ClickHouse

Teradata → ClickHouse

✨ Key Features

•Direct database-to-database streaming
•Multiple parallelization methods (Ntile, RangeId, DataDriven)
•Zero intermediate storage required
•Minimal memory footprint

🚀 Performance

•Configurable degree of parallelism
•Optimized for large datasets
•Production-grade reliability
•Real-time progress monitoring