This is a read-only copy of the MariaDB Knowledgebase generated on 2025-05-02. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB Deployment

Procedures are provided to download, install, set-up, configure, and test MariaDB products.

Upgrade instructions are also available.

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.

Transactional (OLTP)

TopologyDiagramFeatures
• Primary/Replica Topologyes-primary-replica-topologyMariaDB Replication
• Highly available
• Asynchronous or semi-synchronous replication
• Automatic failover via MaxScale
• Manual provisioning of new nodes from backup
• Scales reads via MaxScale
• Enterprise Server 10.3+, MaxScale 2.5+
• Galera Cluster Topologyes-galera-cluster-topologyGalera Cluster Topology Multi-Primary Cluster Powered by Galera for Transactional/OLTP Workloads
• InnoDB Storage Engine
• Highly available
• Virtually synchronous, certification-based replication
• Automated provisioning of new nodes (IST/SST)
• Scales reads via MaxScale Enterprise Server 10.3+, MariaDB Enterprise Cluster (powered by Galera), MaxScale 2.5+

Analytical (OLAP, Data Warehousing, DSS)

TopologyDiagramFeatures
• ColumnStore Object Storage Topologyes-columnstore-topology-s3Columnar storage engine with S3-compatible object storage
• Highly available
• Automatic failover via MaxScale and CMAPI
• Scales reads via MaxScale
• Bulk data import
• Enterprise Server 10.5, Enterprise ColumnStore 5, MaxScale 2.5
• Enterprise Server 10.6, Enterprise ColumnStore 23.02, MaxScale 22.08
• ColumnStore Shared Local Storage Topologyes-columnstore-topology-nfsColumnar storage engine with shared local storage
• Highly available
• Automatic failover via MaxScale and CMAPI
• Scales reads via MaxScale
• Bulk data import
• Enterprise Server 10.5, Enterprise ColumnStore 5, MaxScale 2.5
• Enterprise Server 10.6, Enterprise ColumnStore 23.02, MaxScale 22.08

Hybrid Workloads

TopologyDiagramFeatures
• HTAP Topologyes-columnstore-htap-topology-s3Single-stack hybrid transactional/analytical workloads
• ColumnStore for analytics with scalable S3-compatible object storage
• InnoDB for transactions
• Cross-engine JOINs
• Enterprise Server 10.5, Enterprise ColumnStore 5, MaxScale 2.5
• Enterprise Server 10.6, Enterprise ColumnStore 23.02, MaxScale 22.08

Spider Topologies

TopologyDiagramFeatures
• Spider Federated Topologyes-spider-federated-mariadb-topologyRead 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
• Enterprise Server 10.3+, Enterprise Spider
• Spider Sharded Topologyes-spider-sharded-mariadb-topologyShard 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
• Enterprise Server 10.3+, Enterprise Spider
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.