🐬MariaDB

NEW

An open-source relational database management system, forked from MySQL, offering compatibility and enhanced features.

DESCRIPTION

MariaDB is a community-developed fork of MySQL created to ensure open development and licensing continuity. It provides SQL-standard features, multiple storage engines, robust replication, and clustering with Galera. MariaDB emphasizes performance, security, and compatibility with MySQL clients and tools. Extensions include MariaDB ColumnStore for analytics and temporal tables for auditing. It fits OLTP workloads, mixed workloads, and open-source stacks requiring relational databases.

ALTERNATIVE DEFINITIONS

MariaDB Foundation

MariaDB Server is one of the most popular open source relational databases.

Positions MariaDB as a popular open-source RDBMS stewarded by a foundation.

Source

MariaDB plc

MariaDB is an open source relational database that is compatible with MySQL and designed for performance and reliability.

Emphasizes MySQL compatibility and performance focus.

Source

RELATED TERMS

SQL InnoDB Galera Cluster ACID Replication Stored Procedure Multiversion Concurrency Control Columnar Database

COMPETING TERMS

MySQL PostgreSQL

KNOWLEDGE AREAS

Data Storage & Operations Data Engineering Programming Languages Data Management

TARGET AUDIENCE

Software Developer Data Engineer Data Architect

EXTERNAL SOURCES

• Wikipedia - MariaDB
• MariaDB - Official documentation portal
• MariaDB Foundation - Community and releases
• Galera Cluster - Synchronous clustering docs

TOP QUESTIONS

Why was MariaDB created and how does it relate to MySQL?

MariaDB was forked from MySQL to ensure continued open development. It remains highly compatible with MySQL while evolving its own features and engines.

Category: History

What workloads is MariaDB best suited for?

MariaDB excels in OLTP, mixed read/write workloads, and systems needing mature SQL features, replication, and clustering.

Category: UseCases

How does MariaDB achieve high availability?

High availability is achieved with replication and Galera Cluster for synchronous multi-master setups, plus proxy/load balancer integration.

Category: Architecture

What are MariaDB storage engines?

MariaDB supports pluggable engines like InnoDB and ColumnStore, allowing tuning for transactional or analytical performance.

Category: Features

How compatible is MariaDB with MySQL clients and tools?

MariaDB generally works with MySQL connectors and tools, though edge cases may require testing due to diverging features.

Category: Compatibility

What are common mistakes when migrating from MySQL to MariaDB?

Assuming perfect feature parity and skipping performance regression tests can cause issues. Validate engine choices and query plans.

Category: Mistakes

How does MariaDB compare with PostgreSQL?

PostgreSQL offers advanced SQL features and extensions; MariaDB emphasizes MySQL compatibility and simpler operational patterns. Choice depends on ecosystem and feature needs.

Category: Comparison

How is MariaDB secured?

Use TLS, least-privilege accounts, strong authentication plugins, auditing, and encryption at rest with key management.

Category: Security

What performance tuning steps help MariaDB?

Tune buffer pools, query cache settings (if applicable), indexes, and schema design. Monitor slow queries and leverage EXPLAIN.

Category: BestPractices