MariaDB Platform Deployment

This MariaDB Deployment Guide details how to download, install, set-up, configure, upgrade, downgrade, and test MariaDB products.

MariaDB products can be deployed in many different topologies. The topologies on this page are representative. MariaDB products can be deployed to form other topologies, leverage advanced product capabilities, or combine the capabilities of multiple topologies.

Production-Ready Transactional

Topology

Diagram

Features

Xpand Performance

Xpand Performance Topology
  • Distributed SQL with lowest latency

  • Elastic scale-out and scale-in

  • Highly available and fault tolerant

  • Automated provisioning of new nodes

  • Scales reads and writes

  • Synchronous replication with automatic rebalancing

  • Xpand 5.3, MaxScale 2.5

Xpand Storage Engine

Xpand Performance Topology
  • Distributed SQL with Enterprise Server integration

  • Elastic scale-out and scale-in

  • Highly available and fault tolerant

  • Automated provisioning of new nodes

  • Scales reads and writes

  • Synchronous replication with automatic rebalancing

  • Xpand 5.3, MaxScale 2.5, ES 10.5

Enterprise Cluster

ES Galera Cluster Topology
  • Transactional clustering for InnoDB

  • Certification-based replication

  • Highly available

  • Automated provisioning of new nodes

  • Scales reads

  • Virtually-synchronous replication

  • ES 10.2+, MaxScale 2.3+

  • MariaDB Enterprise Cluster powered by Galera

Primary/Replica

ES Primary/Replica Topology
  • MariaDB Replication

  • Highly available

  • Manual provisioning of new nodes from backup

  • Scales reads

  • Asynchronous or semi-synchronous replication

  • ES 10.2+, MaxScale 2.3+

Production-Ready Columnar

MariaDB Enterprise ColumnStore is a columnar storage engine for online analytical processing (OLAP), data warehousing, business intelligence, and hybrid transactional-analytical processing (HTAP). MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server. MariaDB Enterprise ColumnStore is a component of MariaDB Platform.

MariaDB Enterprise ColumnStore is available for production in the cloud on MariaDB SkySQL DBaaS. For additional information, see the MariaDB SkySQL Documentation

MariaDB Enterprise ColumnStore is available for production on-premises deployments. For on-premises deployment instructions, choose a topology and version:

Topology

Diagram

Features

Enterprise ColumnStore with Object Storage
Enterprise ColumnStore with Object Storage
  • Analytics with scalable S3-compatible storage

  • Highly available

  • Scales reads

  • Data protection using S3-compatible object storage

  • ES 10.5, ColumnStore 5, MaxScale 2.5

Enterprise ColumnStore with Shared Local Storage
Enterprise ColumnStore with Shared Local Storage
  • Analytics

  • Highly available

  • Scales reads

  • Data protection using shared local storage

  • ES 10.5, ColumnStore 5, MaxScale 2.5

HTAP
HTAP with Object Storage
  • Single-Stack Hybrid Transactions/Analytics

  • ColumnStore for analytics

  • InnoDB for transactions

  • Cross-engine JOINs

  • ES 10.5, ColumnStore 5, MaxScale 2.5

MariaDB Enterprise ColumnStore supports multiple topologies. The options described on this page are representative of basic product capabilities.

MariaDB products can be deployed to form other topologies that leverage advanced product capabilities and combine the capabilities of multiple topologies.

Federation, Sharding, and ODBC

To deploy the Enterprise Spider storage engine with MariaDB Enterprise Server, choose an Enterprise Spider topology and an ES version:

Topology

Diagram

Features

Federated MariaDB Enterprise Spider
Federated MariaDB Enterprise Spider Topology
  • Read from and write to tables on remote ES nodes

  • Spider Node uses Spider storage engine for Federated Spider Tables

  • Federated Spider Table is a "virtual" table

  • Spider uses MariaDB foreign data wrapper to query Data Table on Data Node

  • Data Node uses non-Spider storage engine for Data Tables

  • Supports transactions

  • ES 10.3+

Sharded MariaDB Enterprise Spider
Sharded MariaDB Enterprise Spider Topology
  • Shard tables for horizontal scalability

  • Spider Node uses Spider storage engine for Sharded Spider Tables

  • Sharded Spider Table is a partitioned "virtual" table

  • Spider uses MariaDB foreign data wrapper to query Data Tables on Data Nodes for each partition

  • Data Node uses non-Spider storage engine for Data Tables

  • Supports transactions

  • ES 10.3+

ODBC MariaDB Enterprise Spider
ODBC MariaDB Enterprise Spider Topology
  • Read from and write to tables on ODBC Data Sources

  • Spider Node uses Spider storage engine for ODBC Spider Tables

  • ODBC Spider Table is a "virtual" table

  • Spider uses ODBC foreign data wrapper to query ODBC Data Source

  • Supports transactions

  • ES 10.5

Archiving in S3

Topology

Diagram

Features

S3 Storage Engine

S3 Storage Engine Topology
  • Read-only access to archived data on S3 object storage

  • Archive a table with only ALTER TABLE .. ENGINE=S3

  • ES 10.3+

Single-Product Instructions

Product

Description

MariaDB Enterprise Server

Modern SQL database with Enterprise lifecycle

MariaDB Enterprise ColumnStore

Columnar data store

MariaDB Community Server

Modern SQL database