MariaDB ColumnStore

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.

Features

• Columnar Storage: Optimized for analytical queries by storing data in columns for faster processing.
• Massive Scalability: Handles petabyte-scale data with distributed architecture across multiple nodes.
• High-Speed Analytics: Executes complex queries quickly using parallel processing and compression.
• SQL Compatibility: Supports standard SQL, making integration with existing tools seamless.
• Open Source: Free to use and customizable, backed by a strong community and enterprise support.