Webinar Slides. Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

By Adam Brown and Robert Hodges Slides for the Webinar, presented on June 23, 2020 Webinar recording is available here 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.

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

By James Hartig and Robert Hodges Slides for the Webinar, presented on June 16, 2020 Webinar recording is available here Advertising is dying in the wake of privacy and adblockers. Join us for a conversation with James Hartig, a Co-Founder at Admiral (getadmiral.com), 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!

Read More
ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications

August 6, 2020 with Alexander Zaitsev and Robert Hodges Curious what's new in ClickHouse? This talk is for you! Join us to learn about new features of ClickHouse, ranging from tiered storage to compact MergeTree format to SQL join improvements. We'll also preview new features like object storage and LDAP support planned for the remainder of 2020. Finally, we'll discuss Altinity Stable Releases and how they help you decide when features are ready for production use. Don't miss this opportunity to get current on ClickHouse improvements to help you build even better analytics!

Read More
Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users

July 9, 2020 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 Buch of Instana. They describe how the Instana team uses ClickHouse to power their solution, lessons they have learned, and how they integrated them back into Instana's own ClickHouse monitoring features. Along the way, you'll learn how to set up Instana on ClickHouse, what important metrics you should track, how ClickHouse is integrated in end-to-end distributed tracing, and what level of automation is available for root cause analysis and alerting.

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.

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

Advertising is dying in the wake of privacy and adblockers. Join us for a conversation with James Hartig, a Co-Founder at Admiral (getadmiral.com), 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!

Read More
Using Joins in ClickHouse Materialized Views

ClickHouse materialized views provide a powerful way to restructure data in ClickHouse. We have discussed their capabilities many times in webinars, blog articles, and conference talks. One of the most common follow-on questions we receive is whether materialized views can support joins.
The answer is emphatically yes. This blog article shows how. If you are looking for a quick answer, here it is: materialized views trigger off the left-most table of the join. The materialized view will pull values from right-side tables in the join but will not trigger if those tables change.

Read More
ClickHouse Birthday Altinity Stable Release 20.3.12.112

4 years ago, Alexey Milovidov published “Yandex Opens ClickHouse”, a historic blog post that opened up a new era in analytical databases. Since then we consider June 15 as the birthday of ClickHouse. ClickHouse is our beloved child that grows up and matures very rapidly. Like any normal kid, it has some bad habits and a lot of “character.” We teach it and are happy to see how it progresses. Birthdays are a time for presents. For ClickHouse’s 4th birthday we prepared ...

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