Opensource Column Store Databases: MariaDB ColumnStore vs. ClickHouse

Wednesday 11:00 AM - 11:50 AM

@ Texas 5

MySQL/MariaDB

50 minutes conference

Intermediate

Tracks:
MySQL, MariaDB

Running an analytical (OLAP) workload on top of MySQL can be slow and painful. A specifically designed storage format ("Column Store") can significantly improve analytical queries' performance. There are a number of opensource column store databases around. In this talk, I will focus on two of them which can support MySQL protocol: MariaDB ColumnStore and ClickHouse.

I will show some realtime benchmarks and use cases, and demonstrate how MariaDB ColumnStore and ClickHouse can be used for typical OLAP queries. I will also do a quick demo.


Speakers

Alexander Rubin

Alexander Rubin (VirtualHealth)

Director, Data Architecture

Biography:

Alexander has over 10 years industry experience with the MySQL database and related technologies. His specialties are performance tuning, full text search, high availability, database infrastructure architecture and data warehouses. He has helped many MySQL customers design extremely high performance databases with optimized schema and queries.


Connect with Percona

Stay Connected on:

Percona Live 2019 starts in:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863