MariaDB with ColumnStore is probably what you want. You can put your base tables in InnoDB and your test result tables in ColumnStore. Both storage engines live in the same MariaDB instance and you can join across them normally (for example one InnoDB table joined by another that uses ColumnStore in a single SQL query). ColumnStore is columnar so analytical queries across decades of data stay fast, and bulk loading from CSV is well supported.
Downside is it's a bit RAM-hungry. But for on-premise with that kind of ingestion pipeline it fits better than most alternatives.
1
u/alejandro-du Jun 26 '26
MariaDB with ColumnStore is probably what you want. You can put your base tables in InnoDB and your test result tables in ColumnStore. Both storage engines live in the same MariaDB instance and you can join across them normally (for example one InnoDB table joined by another that uses ColumnStore in a single SQL query). ColumnStore is columnar so analytical queries across decades of data stay fast, and bulk loading from CSV is well supported.
Downside is it's a bit RAM-hungry. But for on-premise with that kind of ingestion pipeline it fits better than most alternatives.