{"repo":"Altinity/clickhouse-sink-connector","free":true,"listed":false,"github":"https://github.com/Altinity/clickhouse-sink-connector","clone":"git clone https://github.com/Altinity/clickhouse-sink-connector.git","description":"Replicate data from MySQL, Postgres and MongoDB to ClickHouse®","language":"Python","stars":343,"topics":["avro","kafka","kafka-connect","clickhouse","postgresql","replication","cdc","debezium","mysql","mongo"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"Latest Releases https://github.com/Altinity/clickhouse-sink-connector/releases Altinity Sink Connector for ClickHouse® The Altinity Sink Connector moves data automatically from transactional database tables in MySQL and PostgreSQL to ClickHouse for analysis. Features Refer Feature Matrix for detailed features. Initial data dump and load(MySQL) Version History(Experimental) Change data capture of new transactions using Debezium Automatic loading into ClickHouse Sources: Support for MySQL, PostgreSQL (other databases experimental) Target: Support for ClickHouse ReplacingMergeTree Able to recover/restart from failures on source or target Handle upstream schema changes automatically Checksum-based table comparisons Scalable to 1000s of tables Multiple deployment models Lightweight: single process that transfers from source to target. Kafka: separate source and target processes using Kafka as transport. Distribution as Docker container Getting Started QuickStart Guide: Lightweight (MySQL)\\ QuickStart Guide: Lightweight (PostgreSQL)\\ QuickStart Guide: Lightweight (Oracle)(Experimental)\\ QuickStart Guide: Kafka Blog Articles First two are good tutorials on MySQL and PostgreSQL respectively. - Altinity Sink Connector (MySQL) - Altinity Sink Connector (PostgreSQL) - ClickHouse as an analytic extension for MySQL Reference Documentation General Architecture Overview Lightweight Sink Connect CLI Connection Pool Mutable Data Handling ClickHouse Table Engine Types Troubleshooting TimeZone ","default_branch":null,"files":null,"tree":[],"storefront":"/r/Altinity","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Altinity/clickhouse-sink-connector/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}