ClickHouse
Overview
ClickHouse is an open-source columnar database management system designed for online analytical p...
How to Connect
How-To Guides
Creating a Database
ClickHouse is a high-performance columnar database designed for real-time analytical processing. ...
Upgrading to Major Version
Upgrading a database service on Elestio can be done without creating a new instance or performing...
Installing and Updating an Extension
ClickHouse supports custom extensions via [User Defined Functions (UDFs)], external dictionaries,...
Creating Manual Backups
Regular backups are essential when running a ClickHouse deployment, especially if you’re using it...
Restoring a Backup
Restoring ClickHouse backups is essential for disaster recovery, staging environment duplication,...
Identifying Slow Queries
Slow queries can impact ClickHouse performance, especially under high load or with inefficient qu...
Detect and terminate long-running queries
ClickHouse is a high-performance, column-oriented OLAP database, but poorly optimized or long-run...
Preventing Full Disk Issues
Running out of disk space in a ClickHouse environment can cause query failures, part merge errors...
Checking Database Size and Related Issues
As your ClickHouse data grows especially with large analytical workloads or high-ingestion pipeli...
Database Migration
Cloning a Service to Another Provider or Region
Migrating or cloning ClickHouse across cloud providers or geographic regions is essential for opt...
Database Migration Services for ClickHouse
Elestio provides a easy and reliable approach for migrating ClickHouse instances from various env...
Manual ClickHouse Migration Using clickhouse-backup
Manual migrations using ClickHouse’s native tools, such as clickhouse-client, clickhouse-backup, ...
Cluster Management
Overview
Elestio provides a complete solution for setting up and managing software clusters. This helps us...
Deploying a New Cluster
Creating a cluster is a foundational step when deploying services in Elestio. Clusters provide ...
Node Management
Node management plays a critical role in operating reliable and scalable infrastructure on Elesti...
Adding a Node
As your application usage grows or your infrastructure requirements change, scaling your cluster ...
Promoting a Node
Clusters can be designed for high availability or role-based workloads, where certain nodes may t...
Removing a Node
Over time, infrastructure needs change. You may scale down a cluster after peak load, decommissio...
Backups and Restores
Reliable backups are essential for data resilience, recovery, and business continuity. Elestio pr...
Cluster Resynchronization
In distributed systems, consistency and synchronization between nodes are critical to ensure that...
Database Migration
When managing production-grade services, the ability to perform reliable and repeatable database ...
Delete a Cluster
When a cluster is no longer needed whether it was created for testing, staging, or an obsolete wo...
Restricting Access by IP
Securing access to services is a fundamental part of managing cloud infrastructure. One of the mo...