Setting up Cross-Region ClickHouse® Replication in Kubernetes
If your ClickHouse® applications need to be accessible from multiple regions, you need replicas of your data in those regions. Here’s how to get started!
Replicating data from PostgreSQL to ClickHouse® with the Altinity Sink Connector
Introducing a new tool to replicate data from PostgreSQL to ClickHouse. The tool is a single executable with no additional dependencies. The tool can be used to perform initial load/dump and to replicate changes in real-time from PostgreSQL to ClickHouse
Using ClickHouse® as an Analytic Extension for MySQL
With Altinity and Percona’s partnership, building more powerful, cost-efficient applications using ClickHouse as an analytic extension for MySQL is now a reality.
Deep Dive on ClickHouse®: Sharding and Replication Webinar
This talk walks you through sharding and replication, showing how Altinity experts enable clusters that deliver fast queries over petabytes of data. Starting with basic definitions of each, then moving to practical issues.
Fast MySQL to ClickHouse® Replication: Announcing the Altinity Sink Connector for ClickHouse
Want fast MySQL analytics? Then check out the Altinity Sink Connector for ClickHouse. Merging the power of ClickHouse with MySQL, the sink connector lets you replicate data from MySQL to ClickHouse in real-time.
A New Way to Restore ClickHouse® After ZooKeeper Metadata Is Lost
Every ClickHouse user has experienced data loss due to user error or operational failure with Zookeeper at least once in their lifetime. If a failure resulted in metadata loss, ClickHouse tables can turn into pumpkins–you can query but you cannot…
Webinar: Introduction to the Mysteries of ClickHouse® Replication
Built-in replication is a powerful ClickHouse feature that helps scale data warehouse performance as well as ensure high availability. This webinar will introduce how replication works internally, explain configuration of clusters with replicas, and show you how to set up…
Realtime replication from MySQL to ClickHouse® in practice
July 2, 2018Vladislav Klimenko from Altinity and Valery Panov from Ivinco presented a talk at HighLoad Siberia 2018 conference recently. They described the real problem that Ivinco faced and how it has been solved with migration of analytics from MySQL…
Circular Replication Cluster Topology in ClickHouse®
In some cases, there is a need to configure a distributed cluster with replication but there are not enough servers in order to place every replica on a separate node. It is better to have multiple replicas at the same…
Archiving MySQL Tables in ClickHouse®
Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. In this article Percona’s blogger Alexander Rubin is talking about archiving MySQL tables in ClickHouse for storage and…
ClickHouse® Data Distribution
Jun 5, 2017 ClickHouse data distribution and replication are fundamental techniques for building reliable and scalable ClickHouse systems. In this article we will explain how it works from the user perspective