Setup & maintenance
Learn how to set up, deploy, monitor, and backup ClickHouse® with step-by-step guides.
Can not connect to my ClickHouse® server
Can not connect to my ClickHouse® server.
cgroups and kubernetes cloud providers
cgroups and kubernetes cloud providers.
ClickHouse® and different filesystems
ClickHouse® and different filesystems.
ClickHouse® Access Control and Account Management (RBAC)
Access Control and Account Management (RBAC).
Client Timeouts
How to prevent connection errors.
Compatibility layer for the Altinity Kubernetes Operator for ClickHouse®
Page description for heading and indexes.
How to convert uniqExact states to approximate uniq functions states
A way to convert to uniqExactState to other uniqStates (like uniqCombinedState) in ClickHouse®
Custom Settings
Using custom settings
ClickHouse® data/disk encryption (at rest)
Example how to encrypt data in tables using storage policies.
DR two DC
Disaster Recovery configuration between two data centers
How to recreate a table in case of total corruption of the replication queue
How to recreate a table in case of total corruption of the replication queue.
Jemalloc heap profiling
Example of .xml config to enable remote pprof style access
Logging
Logging configuration and issues
Precreate parts using clickhouse-local
Precreate parts using clickhouse-local.
Recovery after complete data loss
When disaster strikes
source parts size is greater than the current maximum
source parts size (…) is greater than the current maximum (…)
Timeouts during OPTIMIZE FINAL
Timeout exceeded ... or executing longer than distributed_ddl_task_timeout during OPTIMIZE FINAL.
Use an executable dictionary as cron task
If you need to execute scheduled tasks, you can use an executable dictionary like it was a cron task.
Useful settings to turn on/Defaults that should be reconsidered
Useful settings to turn on.
Who ate my CPU
Queries to find which subsytem of ClickHouse® is using the most of CPU.
Server configuration files
How to organize configuration files in ClickHouse® and how to manage changes
Altinity Backup for ClickHouse®
Altinity Backup for ClickHouse® + backblaze
AWS EC2 Storage
AWS EBS, EFS, FSx, Lustre
ClickHouse® Monitoring
Tracking potential issues in your cluster before they cause a critical error
Converting MergeTree to Replicated
Adding replication to a table
High CPU usage in ClickHouse®
Getting CPU usage under control
Memory Overcommiter
Enable Memory overcommiter instead of ussing max_memory_usage per query
Moving a table to another device
Moving a table to another device.
System tables ate my disk
When the ClickHouse® SYSTEM database gets out of hand
ClickHouse® Replication and DDL queue problems
Finding and troubleshooting problems in the replication_queue and distributed_ddl_queue
Suspiciously many broken parts
Debugging a common error message
Who ate my ClickHouse® memory?
“It was here a few minutes ago…”