HTAP with MariaDB Platform
summary
MariaDB Platform combines the MariaDB server, the MaxScale proxy and the ColumnStore engine to run HTAP on one entry point, with MaxScale doing routing, caching, firewalling, throttling and replication offload. A three‑node AWS demo runs multi‑engine joins (columnstore + InnoDB joins) and returns a complex query in ~1.7s. Customers report stores from 10 TB to 30 TB and 100 billion rows; ColumnStore shards by column extents (~8M rows) and recommends ~1 node per 10 TB. New S3 storage plugin cuts storage cost dramatically.
AI-written summary · about
chapters (15)
- 0:00Introduction to MariaDB
- 1:09What is HTAP
- 2:37User experience and data access
- 4:48HTAP use cases
- 7:38Platform X overview
- 14:14MariaDB server features
- 16:04MaxScale proxy layer
- 21:51OLAP setup with MaxScale
- 23:36Smart query router
- 25:04ColumnStore engine
- 27:35ColumnStore adapters
- 32:17Live demo introduction
- 33:17Demo queries and joins
- 37:20Complex query performance
- 38:02Q&A session
related talks
29mHTAP vs OLTP/OLAP
36mHow Can HTAP Databases Simplify Your Data Infrastructure?
25mThe future of databases: Combining operational and analytical data at massive scale
18mBuilding Data Lake with MariaDB ColumnStore
17mUsing MariaDB ColumnStore with Power BI for Visualization and Reporting
26mSoar Higher With MariaDB SkySQL - The Ultimate MariaDB Cloud
32mHPC Multi-Cluster Database Deployment: Service Level and Availability Driven Refactoring
58mIntroducing ScaleDB, the New Clustered, Distributed Storage Engine for MySQL (Part 1)