ClickHouse DBA

Troubleshooting issues while starting the clickhouse-server

Host OS: Ubuntu 22.04 ClickHouse version: 22.6.3.35   Using the pre-compiled packages is the recommended way for installing ClickHouse. The...

Multiple settings profiles for a ClickHouse user

In ClickHouse, a group or collection of settings and constraints can be stored as a settings profile, which can then...

ClickHouse Backup Strategies – Part 1

Introduction In ClickHouse, replication does not protect the system from accidental deletes on tables or some records on the tables....

Ingesting Data From MongoDB

In this article, you will learn how to read your data from ClickHouse which is stored in MongoDB. MongoDB engine...

Examining Errors Generated By ClickHouse

Log of query execution Controlled by session level setting send_logs_level Possible values: ‘trace’, ‘debug’, ‘information’, ‘warning’, ‘error’, ‘fatal’, ‘none’ Can be used with clickhouse-client...