Sync Clickhouse with MySQL/MongoDB Company: Xiaoxin Tech. Industry: Education Team: Big Data Leader: wangchao@xiaoheiban.cn About 100 billion data this year till now 30 million users We use config file needed for a new Clickhouse table ● Init and keep syncing data in one app for a table ● Sync multiple data source to Clickhouse in minutes PTS Provider Transform Sinker ● Major Provider Must config file needed for a new Clickhouse table ● Init and keep syncing data in one app for a table ● Sync multiple data source to Clickhouse in minutes BONUS Time travel history state Create Update Update

Sync Clickhouse with MySQL/MongoDB Company: Xiaoxin Tech. Industry: Education Team: Big Data Leader: wangchao@xiaoheiban.cn About 100 billion data this year till now 30 million users We use config file needed for a new Clickhouse table ● Init and keep syncing data in one app for a table ● Sync multiple data source to Clickhouse in minutes PTS Provider Transform Sinker ● Major Provider Must config file needed for a new Clickhouse table ● Init and keep syncing data in one app for a table ● Sync multiple data source to Clickhouse in minutes BONUS Time travel history state Create Update Update

..............................................................................36 4.2.6. Function Calls..............................................................................................36 4 .......................................................................36 4.2.8. Window Function Calls................................................................................38 4.2.9. Type Casts ...................................................................425 17.3.1. Server Start-up Failures ...........................................................................426 17.3.2. Client Connection

..............................................................................40 4.2.6. Function Calls.................................................................................................. .......................................................................40 4.2.8. Window Function Calls.......................................................................................42 4.2.9. Type ...................................................................452 17.3.1. Server Start-up Failures ..................................................................................453 17.3.2. Client

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Semi-Sync . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Critical failures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Alertable failures . . . . . . . . . . . . . . . isolated from failures in other cells. It is typically either a full data center or a subset of a data center, sometimes called a zone or availability zone. Vitess gracefully handles cell-level failures, such

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Semi-Sync . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Critical failures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Alertable failures . . . . . . . . . . . . . . . isolated from failures in other cells. It is typically either a full data center or a subset of a data center, sometimes called a zone or availability zone. Vitess gracefully handles cell-level failures, such

..............................................................................36 4.2.6. Function Calls..............................................................................................36 4 .......................................................................36 4.2.8. Window Function Calls................................................................................38 4.2.9. Type Casts ...................................................................412 17.3.1. Server Start-up Failures ...........................................................................413 17.3.2. Client Connection

..............................................................................40 4.2.6. Function Calls.................................................................................................. .......................................................................40 4.2.8. Window Function Calls.......................................................................................42 4.2.9. Type ...................................................................440 17.3.1. Server Start-up Failures ..................................................................................441 17.3.2. Client

..............................................................................36 4.2.6. Function Calls..............................................................................................36 4 .......................................................................36 4.2.8. Window Function Calls................................................................................38 4.2.9. Type Casts ...................................................................391 17.3.1. Server Start-up Failures ...........................................................................392 17.3.2. Client Connection

..............................................................................40 4.2.6. Function Calls.................................................................................................. .......................................................................40 4.2.8. Window Function Calls.......................................................................................42 4.2.9. Type ...................................................................417 17.3.1. Server Start-up Failures ..................................................................................418 17.3.2. Client