MariaDB ColumnStore Engine Docker Demo: Taking Analytics to New Speed

Two links is all you need to upgrade MariaDB Server for operational analytics with MariaDB Columnstore! Join Kathryn Sizemore who show you how to load a realistic 38M record data set and compare load timing, disk storage used, and query speed as a way of illustrating the benefits of these two storage engines.

Related Resources

Table of Contents
0:00 Intro
1:32 Agenda
2:25 Comparing InnoDB engine and Columnstore
6:23 Columnstore Docker Image
9:19 Data Load & Storage Comparison
13:12 Query Speed comparison
16:03 Results Chart

►Subscribe to the MariaDB channel:

MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.

#MariaDB #Database #Data #SQL #analytics

[PieterHumphrey-mbd]

so much easier to start with Docker! And whoa, the ingest / query is *wicked fast* for Columnstore

[cyclomiha]

Looks nice. How about WRITES, does the ColumnStore struggle with those?

[palychbasist]

I run docker compose with MaxScale and try to imitate the situation when one of the msc node is disconnected and connected again. I can see in 'mcs cluster status' that dbrm_mode is offline and when I try to make queries from my app I get an error 'Lost connection to DDLProc' until I restart cluster with 'mcs cluster restart' command. Isn't it suppose to work automatically? What other settings may I need? Is this docker image production ready?

[palychbasist]

When I try to run this image using max scale I can't make queries. I get an error ' Cannot execute the statement. DBRM is read only"

[customraspi]

SAP HANA is both transactional and columnar. So why copying all data twice?

[tbone]

The db is crashing on me when trying to do some unions. Have to restart:(. Should the container not run on Mac?

[tomaszt]

why do all computer geeks use only terminal which is not very ergonomic - is it some kind of challenge? why not use some IDE where results would be more user friendly... always wondering

[alexzruss]

what is this ? Can someone help me understand what language is she speaking?