Deployment Guide

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

Galera 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

Topology

Diagram

Features

Enterprise ColumnStore with Object Storage

Enterprise ColumnStore Topology with S3
  • 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 Local Storage

Enterprise ColumnStore Topology with NFS
  • Analytics

  • Highly available

  • Scales reads

  • Data protection using shared storage

  • ES 10.5, ColumnStore 5, MaxScale 2.5

HTAP

HTAP Topology with S3
  • Single-Stack Hybrid Transactions/Analytics

  • ColumnStore for analytics

  • InnoDB for transactions

  • Cross-engine JOINs

  • ES 10.5, ColumnStore 5, MaxScale 2.5

Targeted Features

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+

Spider Federation

Spider Federated MariaDB Topology
  • Interlink a remote MariaDB database

  • Migrate remote table data to local tables

  • JOIN remote tables with local tables

  • Transactionally write to remote tables

  • ES 10.3+

Spider Sharding

Spider Sharded MariaDB Topology
  • Shard large tables between multiple remote MariaDB databases

  • Horizontally partition MariaDB tables

  • Transactionally write to sharded tables

  • ES 10.3+

Spider ODBC

Spider Federated ODBC Topology
  • Interlink a remote non-MariaDB database using ODBC

  • Migrate non-MariaDB table data to MariaDB tables

  • JOIN non-MariaDB tables with MariaDB tables

  • Transactionally write to non-MariaDB tables

  • ES 10.5

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