webinar
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!
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!
ClickHouse® and Apache Parquet: Past, Present, and Future
Apache Parquet, a popular columnar storage format, has become a linchpin for data-driven organizations seeking efficient and scalable solutions.
ClickHouse® can read and write Parquet data at very high speeds which allows interesting integration capability.
In this webinar, we will walk through the existing ClickHouse® functionality, give an overview of performance improvements over the last year, and discuss how ClickHouse® can do even better.
Presenter: Alexander Zaitsev - Altinity co-founder and CTO. ClickHouse® expert since 2016
Eureka! 8 developer tricks for running ClickHouse® on Kubernetes
Kubernetes is a great platform for ClickHouse® with many success stories. What are the tricks that make it possible? This webinar shows 8 practices to help ClickHouse® developers build faster and more cost-efficient analytics on Kubernetes. We'll start with using the Altinity operator, work our way through various techniques to scale up or shut off compute, and end with advice on zero-downtime upgrade. Along the way we'll review key Kubernetes features like node autoscaling. Join us to learn more about data on Kubernetes and impress your friends!
Deep Dive on ClickHouse® Sharding and Replication Webinar
ClickHouse® works out of the box on a single machine, but it gets complicated in a cluster. ClickHouse® provides two scaling-out dimensions -- sharding and replication -- and understanding when and how those should be applied is vital for production and high-load applications. In this webinar we will focus on ClickHouse® cluster setup and configuration, cluster operation in public clouds, executing distributed queries, hedged requests, and more.
ClickHouse® Performance Master Class – Tools and Techniques to Speed up any ClickHouse® App Webinar
ClickHouse® gives impressive performance out of the box. Our webinar will show you how to make it amazing. We start by providing a framework for performance that includes basic drivers like I/O and compute, as well as ClickHouse® structures like compression and indexes. We'll also discuss tools to evaluate performance including ClickHouse® system tables and EXPLAIN. We'll then demonstrate how to evaluate and improve performance for common query use cases ranging from MergeTree data on block storage to Parquet files in data lakes. Join our webinar to become a master at diagnosing query bottlenecks and curing them quickly.
Petabyte-Scale Data in Real-Time: ClickHouse®, S3 Object Storage, and Data Lakes
These days new ClickHouse® applications start with petabyte-sized datasets and scale up from there. Fortunately, ClickHouse® gives you open-source tools for real-time analytics on big data: MergeTree backed by object storage as well as reading on data lakes. We'll start by showing you popular design patterns for ingest, aggregation, and queries on source data. We'll then dig into specific best practices for defining S3 storage policies, reading from Parquet data, backing up, monitoring, and setting up high-performance clusters in the cloud. It's all open source and works in any cloud. Join us!
Petabyte-Scale Data in Real-Time: ClickHouse, S3 Object Storage, and Data Lakes
These days new ClickHouse applications start with petabyte-sized datasets and scale up from there. Fortunately, ClickHouse gives you open-source tools for real-time analytics on big data: MergeTree backed by object storage as well as reading on data lakes. We'll start by showing you popular design patterns for ingest, aggregation, and queries on source data. We'll then dig into specific best practices for defining S3 storage policies, reading from Parquet data, backing up, monitoring, and setting up high-performance clusters in the cloud. It's all open source and works in any cloud. Join us!
Building a Kubernetes Platform for Trillion Row Tables– CN Data at Scale
Kubernetes is an amazing platform for data, but it requires focus to deliver production apps, especially if they are large. In this talk I'll share learnings from operating a database SaaS for ClickHouse as well as helping customers do it themselves. We'll describe some of the attributes of large analytic applications, then discuss common approaches to building platforms to operate them. Our talk will cover use of standard tools like Terraform, Helm, and Argo CD, which work together to bring up Kubernetes and the apps that run inside it. Along the way we'll describe various "aha!" experiences, tools, and even team organization to support large database applications on Kubernetes.
Showing Beautiful ClickHouse® Data with the Altinity Grafana Plugin
The Altinity Grafana Plugin for ClickHouse is the most popular plugin for creating dashboards on ClickHouse data with over 15M downloads. In this webinar, we'll reveal how it works and how you can use it to create flexible, attractive dashboards for ClickHouse. We'll also show how you can use the plugin to create custom dashboards for Altinity.Cloud clusters and introduce some cool samples that work on any ClickHouse server. Finally, we'll discuss the roadmap for the plugin. Join us to learn how to create beautiful data!
The Analytics Easy Button, or: How to Deploy ClickHouse® Services with Terraform, Helm, or Argo CD
Push-button deployment is the holy grail of analytic platforms, but what's the right path to fulfill your quest? In this webinar, we'll show the standard ways to deploy scalable, open-source ClickHouse services on Kubernetes using Terraform, Helm, or Argo CD. Altinity.Cloud shortcuts to bring up fully managed, supported ClickHouse databases are of course included. Expect demos and working code examples you can nab to create your own easy buttons. From there the analytic possibilities are endless: from Kafka sinks for your entire org to observability pipelines that handle gigabytes of data per second. Join us to see how!
User Management in ClickHouse® Databases: The Unabridged Edition
User management is a key problem in any analytic application. Fortunately, ClickHouse has a rich set of features for authentication and authorization. We're going to tell you about all of them. We'll start with the model: users, profiles, roles, quotas, and row policies. Then we'll show you implementation choices from XML files to SQL commands to external identity providers like LDAP. Finally, we'll talk about features on the horizon to improve ClickHouse security. There will be a sample code plus plenty of time for questions. Join us to learn how to manage your users simply and effectively.