Explore ClickHouse Insights on ChistaDATA's Blog

Reflections from PerconaLive 2022 Austin, TX

As a long-term Perconalive veteran, the most recent Perconalive was more than an Open Source Database conference. It meant to be reunited with thought leaders of open source databases; it meant to be there, learn […]

Swiss PGDay 2022

ChistaDATA Inc.

The Swiss conference on PostgreSQL Swiss PGDay 2022 Friday, July 1, 2022 OST Eastern Switzerland University of Applied Sciences, Campus Rapperswil (Switzerland) Covid-19: No pandemic-related restrictions are expected on the Rapperswil campus. Nevertheless, we appeal […]

How to Recover ClickHouse After ZooKeeper Metadata is Corrupted?

ClickHouse Troubleshooting: How to Restore/Recover ClickHouse after ZooKeeper Metadata is Corrupted/Lost

ChistaDATA Inc.

Introduction 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 […]

Backup & Data Restore (DR) in ClickHouse: Part 1

ChistaDATA Inc.

Introduction We at ChistaDATA never recommend Replication Solution as an alternative for Backup or DR. Replication focuses on business continuity, i.e. delivering uninterrupted data infrastructure availability to mission-critical ClickHouse Operations and Backup involves creating a […]

ChistaDATA Real-time Analytics

Building Real-time Analytics Infrastructure with ChistaDATA’s ClickHouse

Shiv Iyer

Introduction 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 […]

Advantages of Column Stores for Real-time Analytics

ChistaDATA Inc.

Introduction In this blog post, I’m going to take on the subject of why we need ColumnStores for Analytics, the options we have, and how ClickHouse is compelling. Background and History Historically popular datastores have […]

ChistaDATA Managed Services 2022

ChistaDATA Inc.

Intro In this blog post, I’d like to introduce ChistaDATA’s vision and strategy of putting our customers first around Managed Services. First of all, I’d like to thank Shiv Iyer Founder and Principal of ChistaDATA […]

ClickHouse February 2022 Release – v22.2

ChistaDATA Inc.

Introduction ClickHouse Development Group is very active (https://clickhouse.com/docs/en/whats-new/changelog/), We at ChistaDATA carefully evaluate new features to recommend customers for adoption (whenever appropriate). Our Support team is committed to providing maximum value for ChistaDATA customers for […]

ClickHouse Data Types: LowCardinality

ChistaDATA Inc.

Introduction ClickHouse LowCardinality feature is not documented in detail and people still mistake the functional relevance of it. ClickHouse has several data types and SQL implementation which is entirely different from other data warehousing systems, […]

ClickHouse Troubleshooting: Not Able to Connect to ClickHouse

Why I am not able to connect to ClickHouse?

ChistaDATA Inc.

Introduction 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 […]