If you’re in need of a columnar storage engineer, say “hello” to #MariaDB #ColumnStore. 👋

It supports real-time analytics on billions of rows and terabytes of #data. It can’t get any better than that.

Get a formal introduction: https://bit.ly/3fqCkFF

🤩 #MariaDB is truly amazing:
Transactional workloads 👉 #InnoDB
Analytical workloads 👉 #ColumnStore
Read-heavy workloads 👉 #Aria
Write-heavy 👉 #MyRocks
Sharding 👉 #Spider
Scale both reads and writes 👉 #Xpand
Use NoSQL queries or export data to Kafka 👉 #MaxScale

Did you know #MariaDB #ColumnStore is 90% compatible with #InnoDB?

I explain how to use ColumnStore for quick and fast analytics.

📺: http://bit.ly/3FyfXZ9

I did not realize that #Ensembl 's #mysql is built with MyISAM engines as the default.
Wondering if #Aria or #ColumnStore engines are a better choice when building with #MariaDB

Well the #ColumnStore engine, was worth the pain to install in #mariadb
Test file of 10M rows, queries to find the cardinality of the unique values of a specific column ('dim1').
16x & 50x faster than the built-in engines InnoDB & Aria