Altinity
ClickHouse Leading Service Provider

Events

Altinity Events and ClickHouse Community Calendar


Webinar: Adding Fast Analytics to MySQL Applications with ClickHouse
Oct
10
6:00 PM18:00

Webinar: Adding Fast Analytics to MySQL Applications with ClickHouse

October 10 , 2019
with Robert Hodges

Successful MySQL applications have a very common scale problem: how to provide analytics when data grows too large for MySQL to handle. Fortunately, there is a good answer. ClickHouse is a popular, open source column store you can use to add fast analytics to MySQL applications. We'll start with an introduction to ClickHouse for MySQL users showing familiar SQL syntax and table engine design. We'll then walk through important features like support for MySQL wire protocol, ability to read data directly from MySQL tables, and different ways to move data from MySQL into ClickHouse. Finally, we'll touch on design approaches that allow you to extend MySQL applications with analytics that can handle billions of rows.
Watch recording

View Event →
ClickHouse October Meetup
Oct
9
6:00 PM18:00

ClickHouse October Meetup

Join us for October Meetup in San Francisco.

"A Modern Database on a Modern Orchestration Platform" - Alan Braithwaite of Segment.io will talk about running ClickHouse smoothly on Kubernetes.
"ClickHouse Performance Tricks" - Robert Hodges of Altinity.com will share some useful tricks on how to make ClickHouse work even faster.

Register here

View Event →
Webinars: Secrets of ClickHouse Query Performance. September 11 or 17
Sep
17
10:00 AM10:00

Webinars: Secrets of ClickHouse Query Performance. September 11 or 17

September 11 or 17 , 2019
with Robert Hodges

ClickHouse is famous for speed. That said, you can almost always make it faster! This webinar uses examples to teach you how to deduce what queries are actually doing by reading the system log and system tables. We'll then explore standard ways to increase query speed: data types and encodings, filtering, join reordering, skip indexes, materialized views, session parameters, to name just a few. In each case we'll circle back to query plans and system metrics to demonstrate changes in ClickHouse behavior that explain the boost in performance. We hope you'll enjoy the first step to becoming a ClickHouse performance guru!

This topic is so important, that we decided to do this webinar twice! Read more to pick your time.

View Event →
Webinars: Secrets of ClickHouse Query Performance. September 11 or 17
Sep
11
10:00 AM10:00

Webinars: Secrets of ClickHouse Query Performance. September 11 or 17

September 11 or 17 , 2019
with Robert Hodges

ClickHouse is famous for speed. That said, you can almost always make it faster! This webinar uses examples to teach you how to deduce what queries are actually doing by reading the system log and system tables. We'll then explore standard ways to increase query speed: data types and encodings, filtering, join reordering, skip indexes, materialized views, session parameters, to name just a few. In each case we'll circle back to query plans and system metrics to demonstrate changes in ClickHouse behavior that explain the boost in performance. We hope you'll enjoy the first step to becoming a ClickHouse performance guru!

This topic is so important, that we decided to do this webinar twice! Read more to pick your time.

View Event →
Webinar: Altinity Cluster Manager. ClickHouse Management for Kubernetes and Cloud
Aug
21
10:00 AM10:00

Webinar: Altinity Cluster Manager. ClickHouse Management for Kubernetes and Cloud

Join us on August 21, 2019 6 pm GMT / 1 pm EST / 10 am PST
Simplified management is a prerequisite for running any data warehouse at scale. Altinity is developing a new web-based console for ClickHouse called the Altinity Cluster Manager. It's now in beta and offers simplified operation of ClickHouse installations for users. In this webinar we introduce the ACM and demonstrate use on Kubernetes as well as Amazon Web Services. Attendees are welcome to sign up as beta testers and provide feedback. Please join us to see the future of Clickhouse management!

Recording is available here

View Event →
DataCon LA
Aug
17
1:30 PM13:30

DataCon LA

  • University of Southern California (map)
  • Google Calendar ICS

Data Warehouse on Kubernetes: Learnings from the ClickHouse Provider
Speaker: Robert Hodges, Altinity CEO
August 17, 2019

Kubernetes is a natural fit to manage high performance databases. We’ll prove this through learnings from work on the ClickHouse Operator, which stands up ClickHouse data warehouses. We’ll cover the architecture of data warehouse on Kubernetes well as specifics like resource design, storage, performance, and monitoring. Challenges aplenty, but opportunities too!

https://www.dataconla.com

View Event →
Meetup: ClickHouse in the South Bay!
Aug
13
6:00 PM18:00

Meetup: ClickHouse in the South Bay!

South Bay, CA, US

Our next ClickHouse meeting will be in the South Bay. We're looking for talks and a venue large enough for 50+ people.
Suggested topics including ClickHouse success stories, showing how to do something clever, etc.. We also welcome lightning talks on any topic.
Contact the hosts if you have talk ideas or a location. See you soon!

Register here

View Event →
Introduction to the Mysteries of ClickHouse Replication
Jul
31
10:00 AM10:00

Introduction to the Mysteries of ClickHouse Replication

Join us on July 31, 2019 6 pm GMT / 1 pm EST / 10 am PST
Built-in replication is a powerful ClickHouse feature that helps scale data warehouse performance as well as ensure high availability. This webinar will introduce how replication works internally, explain configuration of clusters with replicas, and show you how to set up and manage ZooKeeper, which is necessary for replication to function. We'll finish off by showing useful replication tricks, such as utilizing replication to migrate data between hosts. Join us to become an expert in this important subject!

Recording is available here

View Event →
ClickHouse and the Magic of Materialized Views
Jun
26
10:00 AM10:00

ClickHouse and the Magic of Materialized Views

Join us on June 26, 2019 6 pm GMT / 1 pm EST / 10 am PST
Materialized views are a killer feature of ClickHouse that can speed up queries 200X or more.  Our webinar will teach you how to use this potent tool starting with how to create materialized views and load data. We'll then walk through cookbook examples to solve practical problems like deriving aggregates that outlive base data, answering last point queries, and using AggregateFunctions to handle problems like counting unique values, which is a special ClickHouse feature. There will be time for Q&A at the end. At that point you'll be a wizard of ClickHouse materialized views and able to cast spells of your own. 

WEBINAR RECORDING IS AVAILABLE HERE

View Event →
Webinar: Analyzing Billion Row Datasets with ClickHouse
Jun
5
6:00 PM18:00

Webinar: Analyzing Billion Row Datasets with ClickHouse

Join us on June 5, 2019 6 pm GMT / 1 pm EST / 10 am PST
This talk shows how to get sub-second response from datasets containing a billion rows or more. We'll start with defining schema and loading quickly data in parallel.  We will then introduce tricks like LowCardinality datatype, ASOF joins, and materialized views that can reduce query response to thousandths of seconds.  Finally we'll show you metrics and logging to analyze query performance.  After this talk you'll be ready for your first billion rows and many more afterwards. 

Watch recording here

View Event →
Percona Live, Austin
May
28
to May 30

Percona Live, Austin

Altinity is thrilled to be among the sponsors of the event. Meet our team at the Exhibit Hall

Use code “ALTINITY10” to get 10% off registration

Percona Live conferences provide the open source database community with an opportunity to discover and discuss the latest open source trends, technologies and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry.

1. ClickHouse Data Warehouse 101: The First Billion Rows
Speakers: Alexander Zaitsev, Altinity CTO; Robert Hodges, Altinity CEO 
Thursday 2:55 PM - 3:45 PM @ Texas 6

2. Opensource Column Store Databases: MariaDB ColumnStore vs. ClickHouse
Speaker: Alexander Rubin, Percona 
Wednesday 11:00 AM - 11:50 AM, @ Texas 5

3. Beyond Relational Databases: A Look Into MongoDB, Redis, and ClickHouse
Speaker: Marcos Albe, Percona
Thursday 2:55 PM - 3:45 PM, @ Hill Country D

Click "View Event" for detailed information

View Event →