Keeping Your Cloud Native Data Safe: A Common-Sense Guide to Kubernetes, ClickHouse, and Security

Keeping Your Cloud Native Data Safe: A Common-Sense Guide to Kubernetes, ClickHouse, and Security

Cristina Munteanu

Kubernetes is now the default environment for ClickHouse-based analytic platforms. But how to keep your data safe? Our talk is a practical walkthrough of security for ClickHouse on Kubernetes. We’ll show you how to divide the security problem into easily understood pieces. Then we’ll walk through practical ways you can protect data using the Altinity Operator for ClickHouse, Kubernetes Secrets, managed Kubernetes, and more. You don’t have to be a security wizard to protect your ClickHouse data. Common sense and a little organization will do. Watch it now and find out how!

The Tournament of AWS CPUs in Altinity.Cloud

The Tournament of AWS CPUs in Altinity.Cloud

Alexander Zaitsev

Dive into our latest blog to explore a rigorous ClickHouse benchmark tournament, featuring AWS’s 7th-gen Intel m7i, AMD m7a, and Graviton m7g instances. With Altinity.Cloud’s easy configuration, discover which instance offers the best price-performance ratio for your cloud operations. Find your optimal AWS instance for ClickHouse deployments through our concise analysis.

Locking Down ClickHouse Networking (Part 2)

Locking Down ClickHouse Networking (Part 2)

Vitaliy Zakaznikov

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)

Vitaliy Zakaznikov

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.

Low-Cost ClickHouse clusters using Hetzner Cloud with Altinity.Cloud Anywhere

Low-Cost ClickHouse clusters using Hetzner Cloud with Altinity.Cloud Anywhere

Vitaliy Zakaznikov

For many developers running ClickHouse economically is very important and Altinity provides the tools to do so. This article will guide you on how to quickly setup a small ClickHouse cluster on Hetzner Cloud using K3s Lightweight Kubernetes and Altinity.Cloud Anywhere.

Delivering Better S3 Support in ClickHouse

Delivering Better S3 Support in ClickHouse

Alexander Zaitsev

S3-compatible object storage support is critical for ClickHouse applications. There is a new community proposal to make it much better.

Snowflake, BigQuery, or ClickHouse? Pro Tricks to Build Cost-Efficient Analytics for Any Business

Snowflake, BigQuery, or ClickHouse? Pro Tricks to Build Cost-Efficient Analytics for Any Business

Cristina Munteanu

Do you ever look at your bill for Snowflake or BigQuery and just sigh? This talk is for you. We’ll explain how pricing works for popular analytic databases and how to get the best deal. Then we’ll look at how to build an alternative using open-source ClickHouse data warehouses. As the pros say, open source may be free but it ain’t cheap! We’ll teach you the tricks to build your own ClickHouse analytic stack that’s less expensive and faster than Snowflake. Join us to become a wizard of cloud cost management.

Using S3 Storage and ClickHouse: Basic and Advanced Wizardry

Using S3 Storage and ClickHouse: Basic and Advanced Wizardry

Cristina Munteanu

S3-compatible object storage can reduce cost and improve flexibility in ClickHouse analytics. This talk helps develop the legerdemain to use it well. We’ll start with standard use patterns like tiered storage and archiving to Parquet. Next, we’ll dig into the details of using object storage in ClickHouse tables: storage policies, authentication, caching, and zero-copy replication. Finally, we’ll present expert tips on topics like S3 cost optimization, designing for mutable data, backup, and others. Join our expert presenters and bring your questions!

Caching in ClickHouse – The Definitive Guide Part 1

Caching in ClickHouse – The Definitive Guide Part 1

Alexander Zaitsev

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.