ClickHouse

  1. Events
  2. ClickHouse

Events Search and Views Navigation

Event Views Navigation

Today

Using S3 Storage and ClickHouse: Basic and Advanced Wizardry

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!

Civo Navigate – Europe 2023

Civo Navigate is a two-day, in-person event that will take place on September 5th & 6th, 2023. Hosted in London, England, Civo Navigate will be held at The Brewery, a premier conference venue in the heart of the city that perfectly complements the cutting-edge content and innovative nature of the event. Civo Navigate Europe 2023 is a tech event packed with talks and workshops focused on navigating and succeeding within the cloud native landscape. There will be an overriding theme of innovation, with a focus on helping companies better leverage cloud-native technologies. Education will be at the forefront of all talks and workshops, aimed at various skill levels. Our CEO, Robert Hodges, is one of the brightest minds in the cloud native that will be joining us at the event, including a globally renowned keynote speaker who has inspired many people in the tech space - to be unveiled soon.

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

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.

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

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. Join us to find out how!

API World 2023 – Live Event

Oct 24-26, 2023 · Santa Clara, CA, · Virtual Join thousands of global technical leaders, engineers, software architects, and executives at the world’s largest and longest-running API & microservices event – in its 11th year! Our CEO, Robert Hodges, will be speaking about Building Real-time Analytics on Kubernetes with the ClickHouse Operator. If you are looking to transform your apps with real-time analytics, Kubernetes is an outstanding platform operating high-performance databases and ClickHouse runs well on it. This talk starts from the basics of Kubernetes and introduces an operator we implemented that enables you to stand up ClickHouse clusters. We'll walk through the installation process and bring up a ClickHouse cluster in real time during the talk. We'll then show how running on Kubernetes enables emergent behavior like independent scaling of compute and storage, server fault tolerance, cross-AZ high availability, and rolling upgrades. You'll have enough guidance from this talk to start your journey to real-time data on a robust, cloud-native architecture.

Safety First! Using clickhouse-backup for ClickHouse Backup and Restore

Backups protect ClickHouse data in cases ranging from accidentally dropping a database to data centers burning down. In this webinar, we'll compare available backup options for ClickHouse,  then zero in on clickhouse-backup, a popular open-source project that Altinity maintains. The presentation will discuss how clickhouse-backup works, standard backup and restore commands, and tips for reliable operation in production systems. We'll end with Q & A. Join us if you love your ClickHouse data and want to ensure it sticks around! 

API World 2023 – Virtual Event

Oct 31 – Nov 2, 2023· Virtual Join thousands of global technical leaders, engineers, software architects, and executives at the world’s largest and longest-running API & microservices event – in its 11th year! Our CEO, Robert Hodges, will be speaking about Building Real-time Analytics on Kubernetes with the ClickHouse Operator. If you are looking to transform your apps with real-time analytics, Kubernetes is an outstanding platform operating high-performance databases and ClickHouse runs well on it. This talk starts from the basics of Kubernetes and introduces an operator we implemented that enables you to stand up ClickHouse clusters. We'll walk through the installation process and bring up a ClickHouse cluster in real time during the talk. We'll then show how running on Kubernetes enables emergent behavior like independent scaling of compute and storage, server fault tolerance, cross-AZ high availability, and rolling upgrades. You'll have enough guidance from this talk to start your journey to real-time data on a robust, cloud-native architecture.

ClickHouse Data Management Internals — Understanding MergeTree Storage, Merges, and Replication

ClickHouse manages huge amounts of data in MergeTree tables. But how is MergeTree organized in storage? What's a merge and how does it work? How does ClickHouse replicate data and commands across clusters? And what's a mutation? Our talk explains these features and more. We'll even discuss mysteries like hard links and the DDL replication queue. Our answers focus on the knowledge necessary to run ClickHouse efficiently and avoid problems. Bring your curiosity and questions!