Adventures in ClickHouse Development: Running Integration Tests, Part 2

Adventures in ClickHouse Development: Running Integration Tests, Part 2

In Part 2 of this two-part series, we will pick up where we left off and first try to run all the integration tests by hand. We will first try the naive approach and then go back to ci-runner.py to get the details of how all the integration tests are executed using this script. After that, we will look into what it takes to solve the problem with the Docker images that are required for the tests. Finally, we will use a helper test program that we have developed for running integration tests that addresses the pain points that we discover along the way.

Adventures in ClickHouse Development: Running Integration Tests, Part 1

Adventures in ClickHouse Development: Running Integration Tests, Part 1

Most ClickHouse developers rely heavily on tests executed by the CI/CD pipeline. In this two-part article, we will show how you can execute ClickHouse integration tests by hand as well as look into the complexity of the CI/CD pipeline that is used to run all these tests.

Locking Down ClickHouse Networking (Part 2)

Locking Down ClickHouse Networking (Part 2)

In the second part of this series, we’ll look at how to enable secure connections using SSL and learn how to lock down the server’s access by filtering the hosts and networks from which connections can be made to our server.

Locking Down ClickHouse Networking (Part 1)

Locking Down ClickHouse Networking (Part 1)

Security is not a trivial topic; it is affected by many configuration settings that can be defined for ClickHouse. In part 1 of this series, we identify what ports are opened by default, compiled a list of all the ports that can be opened by ClickHouse, and look at the steps of how we can remove, change, and add open ports.

Caching in ClickHouse – The Definitive Guide Part 1

Caching in ClickHouse – The Definitive Guide Part 1

In this Part 1 article of our latest series on ClickHouse caches, we break down cache types like query caches that are used to speed up SELECT query processing. Read how caches can increase database system performance and capacity.

Analyzing DockerHub Pull Counts with Clickhouse and Altinity.Cloud

Analyzing DockerHub Pull Counts with Clickhouse and Altinity.Cloud

It is very easy to start collecting data into ClickHouse from public HTTP APIs like DockerHub. Follow our step-by-step guide to create a simple ClickHouse app that extracts data from DockerHub and makes it available for reporting.

[Webinar] Own your ClickHouse data with Altinity.Cloud Anywhere

[Webinar] Own your ClickHouse data with Altinity.Cloud Anywhere

Altinity.Cloud is a managed ClickHouse platform for high-performance analytics.
But what if you want to run ClickHouse in your own cloud account? Altinity.Cloud Anywhere does exactly that.
In this webinar, we’ll explain how Altinity.Cloud Anywhere works, then walk through the simple setup procedure to get full cloud management of ClickHouse clusters in your VPCs.
Join us to learn how to have cloud management for your real-time analytic stack while meeting requirements for compliance, control of data, and freedom from lock-in.
Have your cake and eat it too!But what if you want to run ClickHouse in your own cloud account? Altinity.Cloud Anywhere does exactly that.
In this webinar, we’ll explain how Altinity.Cloud Anywhere works, then walk through the simple setup procedure to get full cloud management of ClickHouse clusters in your VPCs.
Join us to learn how to have cloud management for your real-time analytic stack while meeting requirements for compliance, control of data, and freedom from lock-in.
Have your cake and eat it too!