Kubernetes orchestration simplifies many common operational concerns like scheduling, auto-scaling, and failover. It has support for Persistent Volumes and Persistent Volume Claims ( PV & PVC ). Usually, databases that support replication, sharding, and auto-scaling are well suited for Kubernetes. ClickHouse and Kubernetes can perform better together. At ChistaData, we are interested to write […]
How to Restore/Recover ClickHouse after ZooKeeper Metadata is corrupted/lost? When you are building a highly available ClickHouse Infrastrstucture for scale and performance we use ZooKeeper for ClickHouse Replication Management and Operations with ReplicatedMergeTree table engine. You can expect ZooKeeper to face data loss (or a very complex corruption scenario) due to either human error or […]
Everything ClickHouse with ChistaDATA Inc. I have been a full-time Open Source Database Systems Performance Engineer for the last two decades with deep interests in Database Systems Internals, Database Systems (Transaction Processing and ColumnStores) Operations Performance Troubleshooting/Optimization and Unix/Linux Performance Tuning. I architected, built and operated a planet-scale Database Infrastructure for several large internet companies […]
Troubleshooting ClickHouse – Why I am not able to connect to ClickHouse? Why I am not able to connect with ClickHouse Server? We often this ticket on our support function and the error will be like “Connection reset by peer while reading from socket”. So we have a standard, yet simple approach to troubleshooting ClickHouse […]