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.
