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.
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.
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!
Altinity Stable Builds are 100% open-source ClickHouse builds. Every ClickHouse user can benefit from Altinity Stable Builds, certified for production use and API-compatible with official builds from the upstream ClickHouse repo in GitHub with three years of maintenance.
Tired of big bills from Snowflake and BigQuery? Want to keep data in-house? Trying to avoid vendor lock-in? Solve these problems and more by building your own cloud-native analytic service. We start with the architecture of close-source, cloud analytic databases like Snowflake. We then introduce an equally capable design for real-time analytics built entirely on robust open source. Next, we stand up an example using Kubernetes for the run-time, ClickHouse as the query engine, and infrastructure-as-code to deploy apps. Ingest, visualization, and system services are all included. The talk ends with cost numbers to prove that you can operate the service at a fraction of the cost of your current cloud database. (Code used in the platform demo is open source and available on GitHub.) Presenter: Robert Hodges