Author Archives: Roman Nozdrin

DuckDB Storage Engine for MariaDB. When the Sea Lion Learns to Quack.

Written by Written by Roman Nozdrin Leave a comment on DuckDB Storage Engine for MariaDB. When the Sea Lion Learns to Quack.

An early look at the DuckDB storage engine for MariaDB — columnar, vectorized analytics that live right next to your transactional tables.

The problem

MariaDB’s InnoDB is excellent at what it was built for: transactions. Row-by-row inserts, updates, point lookups, strong consistency. But the moment you ask it to scan tens of millions of rows for a multi-way join with a few aggregations, a row store has to work hard.

The usual answer is to stand up a separate analytical system, then build ETL pipelines to copy data into it.

…

Continue reading “DuckDB Storage Engine for MariaDB. When the Sea Lion Learns to Quack.”