Articles by ChistaDATA Inc.

About ChistaDATA Inc.

We are an full-stack ClickHouse infrastructure operations Consulting, Support and Managed Services provider with core expertise in performance, scalability and data SRE. Based out of California, Our consulting and support engineering team operates out of San Francisco, Vancouver, London, Germany, Russia, Ukraine, Australia, Singapore and India to deliver 24*7 enterprise-class consultative support and managed services. We operate very closely with some of the largest and planet-scale internet properties like PayPal, Garmin, Honda cars IoT project, Viacom, National Geographic, Nike, Morgan Stanley, American Express Travel, VISA, Netflix, PRADA, Blue Dart, Carlsberg, Sony, Unilever etc

Getting Started with ClickHouse using clickhouse-local

ChistaDATA Inc.

Introduction Would you like to run ClickHouse queries without a server or attached storage? If your answer is yes, you can prefer clickhouse-local. We want to introduce you to clickhouse-local. It is all about SQL […]

ClickHouse Performance: Decoding Query Execution Plan with EXPLAIN

ChistaDATA Inc.

Introduction Among DBAs, there is much debate regarding the significance of database performance tuning. As we now understand, various types of data are what really power the business world. It should be operating very effectively […]

ClickHouse Release Notes November 2022 Version 22.11

ClickHouse November 2022 Release – Version 22.11

ChistaDATA Inc.

Introduction Every new release includes new features, enhancements, and numerous bug fixes, and the ChistaDATA team always stays on top of the latest releases. On November 17, 2022, ClickHouse version 22.11 was released, and this […]

Deep Dive into the FREEZE Command in ClickHouse

How to use FREEZE command for ClickHouse Backup

ChistaDATA Inc.

Introduction ClickHouse has several backup solutions to restore the disk, database, table, and partition levels. You can access other detailed backup and restore solution documentation here and export/import documentation here. Today, we would like to […]

Sharding in ClickHouse: Part 1

ChistaDATA Inc.

Introduction Sharding is splitting a large table horizontally (row-wise) and storing it in multiple servers. Clickhouse uses distributed table engine for processing the sharded tables. Shards can be internally replicated or non-replicated in ClickHouse. Sharding […]

ClickHouse on Kubernetes: Running ClickHouse Cluster on Amazon EKS

ChistaDATA Inc.

Introduction Kubernetes orchestration simplifies many common operational concerns like scheduling, auto-scaling, and failover. Usually, databases that support replication, sharding, and auto-scaling are well-suited for Kubernetes. ClickHouse and Kubernetes can perform better together. At ChistaDATA, we […]

MySQL to ClickHouse Replication with Sink Connector

ChistaDATA Inc.

Introduction Transactional Databases systems run thousands of transactions per second. ClickHouse, on the other hand, as an analytical database, is the right choice for performing these operations with its features such as columnar storage and […]

ClickHouse Release Notes October 2022 Version 22.10

ClickHouse October 2022 Release – v22.10

ChistaDATA Inc.

Introduction Every new release includes new features, enhancements, and numerous bug fixes, and the ChistaDATA team always stays on top of the latest releases. On October 25, 2022, ClickHouse version 22.10 (October 2022) was released, […]

Data Replication in ClickHouse (Docker Based Setup)

ChistaDATA Inc.

Image Source – Pexels Data replication is the process of storing multiple copies of data to ensure system reliability and improve data availability. ClickHouse supports multi-primary replication, and it is asynchronous (eventually consistent). Every MergeTree table […]

Tracing ClickHouse with OpenTelemetry

ChistaDATA Inc.

Introduction “I am aware that people are disappointed with the performance. But all of our measurements are in the green, so the problem must be somewhere else.” Wouldn’t it be nice to be able to […]