MariaDB ColumnStore extends MariaDB Enterprise Server with distributed, columnar storage and a massively parallel processing (MPP) shared-nothing architecture, transforming it into a standalone or distributed data warehouse for ad hoc SQL queries and advanced analytics without the need to create indexes.
Columnar
Data is stored in a columnar format for fast analytics and up to 90% compression, reducing disk I/O and size of data on disk.
Distributed
Data can be distributed across multiple database instances and queried in parallel to increase query performance and support massive datasets.
Cloud-native
Data can be stored on Amazon S3 compatible object storage, on premises or in the cloud, to benefit from low-cost, unlimited storage.
Modern Analytics Capabilities
Standard SQL
Analyze large amounts of data with standard SQL, including joins with other tables (row or columnar).
Kafka and Spark connectors
Use Kafka and Spark connectors to ingest streaming data and publish machine learning results for interactive, ad hoc analysis.
Direct data loading
CLI import tools as well as C, Java and Python connectors bypass the SQL layer to load data directly to storage from anywhere.
Real-Time Analytics on Live Transactional Data (Alpha)
Access your InnoDB data in real time with the new query accelerator. This powerful feature processes transactional data directly in the ColumnStore engine, enabling you to run fast, parallel OLAP queries on your live business information.
Scale Query Performance, On Demand
Horizontally scale query throughput faster and more efficiently than ever before. New read-replica nodes utilize shared storage to let you add compute resources focused purely on query execution. This allows you to independently and rapidly scale performance to meet demand without needing to redistribute or reimport data.
Automated and Secure Upgrades
Our new upgrades architecture streamlines the entire process, automating nearly every step to save time and increase reliability. Integrated pre- and post-upgrade checks ensure the safety and integrity of your cluster throughout the upgrade process.
Enhanced Data Import and Error Handling
Streamline your data ingestion with new cpimport options. You can now choose to skip all errors to ensure large jobs complete, and automatically isolate any failed records into a separate file for easy review and reprocessing.
Integrated Cluster Management Tools
Essential management capabilities are now built directly into the core cmapi toolkit. Orchestrate backup and restore operations and bundle logs for support with simple, standardized commands, making cluster administration faster and more efficient.
Ready for Modern Enterprise Environments
MariaDB ColumnStore is now fully supported on Red Hat Enterprise Linux 10, ensuring seamless integration into the latest enterprise operating system environments.
Customer Success Stories
See what’s possible when you power your analytics with MariaDB ColumnStore. Explore how businesses like yours are building for the future on our platform.
