ClickHouse July [Virtual] Meetup

Join us on July 15th for our second virtual meetup. With the Bay Area still in some form of shelter-in-place, we will continue with Zoom so that everyone can participate from home. Here’s the current[...]

Read More
Adventures in Observability: How in-house ClickHouse deployment enabled Instana to build better monitoring for users

with Marcel Birkner, Yoann Buch and Robert Hodges Instana is an Application Performance Monitoring solution that provides complete visibility into complex distributed systems, including ClickHouse servers. In this webinar, we welcome Marcel Birkner and Yoann[...]

Read More
Open Source Summit North America (OSS NA). Virtual Experience

Virtual Experience: Open for All – Anytime. Anywhere. June 29 – July 2, 2020

Join us for Altinity presentation:
Breaking out of the Proprietary Cage: Real-time Data Warehouses Come to Open Source
by Robert Hodges, Altinity LTD
Wednesday, July 1 • 12:15pm - 1:05pm

Read More
Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

June 23, 2020
with Adam Brown and Robert Hodges

Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We'll start with an overview of the Mux platform and the importance of real-time feedback. We'll then discuss key features of ClickHouse that enable it to ingest live session data and provide real-time dashboards to Mux users. Finally, we'll talk a bit about the Mux journey to ClickHouse and lessons learned along the way about how data enables content delivery networks.

Register here

Read More
Big Data in Real-Time: How ClickHouse powers Admiral’s visitor relationships for publishers

June 16, 2020
with James Hartig and Robert Hodges

Advertising is dying in the wake of privacy and adblockers. Join us for a conversation with James Hartig, a Co-Founder at Admiral, who helps publishers diversify their revenue and build more meaningful relationships with users. We'll start with an overview of Admiral's platform and how they use large scale session data to power their engagement engine. We'll then discuss the ClickHouse features that Admiral uses to power these real-time decisions. Finally, we'll walk through how Admiral migrated from MongoDB to ClickHouse and some of their plans for future projects. Join us to learn how ClickHouse drives cutting edge real-time applications today!

Register here

Read More
Time Series SF Meetup. Introducing ClickHouse–the fastest data warehouse you’ve never heard of

Abstract:
The market for scalable SQL data warehouses is dominated by proprietary products. ClickHouse is one of the first open source projects to give those products a run for their money. ClickHouse scales to hundreds of nodes with ingest measured in millions of events per second. The user community includes CloudFlare, Cisco, and numerous financial services companies. This talk briefly recounts the history of ClickHouse, starting with its origins at Yandex, then dives into popular features. These include column storage with efficient data encoding and compression, vectorized query execution, sharding and replication, and materialized views. We will end with a short survey of popular use cases and questions.

Speaker Info:
Robert Hodges is the CEO of Altinity, a venture-backed start-up that markets ClickHouse to enterprises. He is also a database geek who has used or worked on over 20 different database systems. Other interests include distributed systems, Kubernetes, and open source. He is an organizer of the San Francisco ClickHouse meetup.

Register here

Read More
Webinar. MORE secrets of ClickHouse Query Performance

May 27, 2020
with Robert Hodges

ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse queries are doing. Then we introduce standard tricks to increase speed: adding CPUs, reducing I/O with filters, restructuring joins, adding indexes, and using materialized views, plus many more. In each case we show how to measure the results of your work. There will as usual be time for questions as well at the end. Sign up now to polish your ClickHouse performance skills!

Read More
Percona Live Online

The first 24-hour, Around-The-World Open Source Database Conference

Percona Live ONLINE is the place to learn about how open source database technology can power your applications, improve your websites, secure your data, and solve critical database issues. Brought to the community, free of charge for anyone to attend.

20:30 EDT
Open Source cost-efficiency in action: analyzing 500B rows on a single ClickHouse server
by Alexander Zaitsev, Altinity CTO

Read More
[DB Seminar] Spring 2020 DB Group: Introducing ClickHouse–the fastest data warehouse you’ve never heard of

Event Date: Monday May 11, 2020 Event Time: 04:30pm Location: https://cmu.zoom.us/j/562649242 Speaker: Robert Hodges [INFO] Title: Introducing ClickHouse–the Fastest Data Warehouse You’ve Never Heard Of The market for scalable SQL data warehouses is dominated by[...]

Read More
Webinar. Strength in Numbers: Introduction to ClickHouse Cluster Performance

April 29, 202
with Robert Hodges
ClickHouse clusters apply the power of dozens or even hundreds of nodes to vast datasets. In this webinar we'll show you how to use the basic tools of replication and sharding to create high performance ClickHouse clusters. We'll study the plumbing of inserts into sharded datasets and how to determine the correct number of shards for your desired writes. We'll similarly look at distributed queries and show how to scale read capacity to desired levels using replicas. Finally, we'll look at techniques for scaling up both shards and replicas to accommodate growth in your dataset.

Read More
Webinar: ClickHouse Monitoring 101: What to monitor and how

April 1, 202
with Robert Hodges and Ned McClain
You are about to deploy ClickHouse into production. Congratulations! But what about monitoring? In this webinar we will introduce how to track the health of individual ClickHouse nodes as well as clusters. We'll describe available monitoring data, how to collect and store measurements, and graphical display using Grafana. We'll demo techniques and share sample Grafana dashboards that you can use for your own clusters.

Watch recording here

Read More
Webinar: ClickHouse Materialized Views. The Magic Continues

February 26, 2020
with Robert Hodges

Materialized views are the killer feature of ClickHouse, and the Altinity 2019 webinar on how they work was very popular. Join this updated webinar to learn how to use materialized views to speed up queries hundreds of times. We'll cover basic design, last point queries, using TTLs to drop source data, counting unique values, and other useful tricks. Finally, we'll cover recent improvements that make materialized views more useful than ever. See you there!

Read More