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!
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.
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.
Open source licensing helped ClickHouse grow. Now the project is moving to open core. There’s reason for users to be concerned.
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.
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.
S3-compatible object storage support is critical for ClickHouse applications. There is a new community proposal to make it much better.
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.
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!
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.