MariaDB vs Percona

Need advice about which tool to choose?Ask the StackShare community!

MariaDB

16.1K
12.5K
+ 1
468
Percona

136
98
+ 1
0
Add tool

MariaDB vs Percona: What are the differences?

Introduction:

MariaDB and Percona are both popular and widely used open-source database management systems. While they share many similarities due to their roots in MySQL, there are several key differences between these two systems that set them apart.

  1. Storage Engines: One major difference between MariaDB and Percona is their default storage engines. MariaDB uses Aria as the default storage engine, which offers support for transactions and crash recovery. On the other hand, Percona Server uses XtraDB, an enhanced version of InnoDB, as the default storage engine. XtraDB provides improved performance and scalability over InnoDB.

  2. Performance Optimizations: Percona Server is known for its performance enhancements and optimizations. It includes various features like the Percona Memory Engine, Thread Pool, and enhanced InnoDB optimizations that help to improve query performance and scalability. While MariaDB also includes some performance improvements, Percona has a stronger focus on performance optimization.

  3. Compatibility: MariaDB aims to be a drop-in replacement for MySQL, offering compatibility with MySQL syntax and APIs. It strives to maintain compatibility with MySQL, making it easier for applications and developers to migrate from MySQL to MariaDB. Percona Server also maintains compatibility with MySQL but offers additional features and optimizations not found in MySQL or MariaDB.

  4. Monitoring and Diagnostic Tools: Percona Server provides a variety of monitoring and diagnostic tools like Percona Monitoring and Management (PMM), which offers a comprehensive set of dashboards and metrics for tracking database performance. MariaDB offers its own set of monitoring and diagnostic tools but does not have an equivalent comprehensive monitoring solution like PMM.

  5. Data Encryption: Another key difference between MariaDB and Percona is the support for data encryption. MariaDB includes built-in data-at-rest encryption capabilities, making it easier to encrypt stored data. In contrast, Percona Server does not provide built-in encryption capabilities, although it can be achieved through third-party tools or plugins.

  6. Community and Support: MariaDB has a larger and more active community compared to Percona, which leads to more community-based support, extensive documentation, and a wide range of resources available. Percona, however, provides enterprise-level support and services, making it an attractive choice for organizations looking for professional support and expertise.

In summary, MariaDB and Percona differ in their default storage engines, performance optimizations, compatibility with MySQL, monitoring and diagnostic tools, data encryption capabilities, and community/support offerings.

Decisions about MariaDB and Percona
Omran Jamal
CTO & Co-founder at Bonton Connect · | 4 upvotes · 538.6K views

We actually use both Mongo and SQL databases in production. Mongo excels in both speed and developer friendliness when it comes to geospatial data and queries on the geospatial data, but we also like ACID compliance hence most of our other data (except on-site logs) are stored in a SQL Database (MariaDB for now)

See more
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn More
Pros of MariaDB
Pros of Percona
  • 149
    Drop-in mysql replacement
  • 100
    Great performance
  • 74
    Open source
  • 55
    Free
  • 44
    Easy setup
  • 15
    Easy and fast
  • 14
    Lead developer is "monty" widenius the founder of mysql
  • 6
    Also an aws rds service
  • 4
    Consistent and robust
  • 4
    Learning curve easy
  • 2
    Native JSON Support / Dynamic Columns
  • 1
    Real Multi Threaded queries on a table/db
    Be the first to leave a pro

    Sign up to add or upvote prosMake informed product decisions

    What companies use MariaDB?
    What companies use Percona?
    See which teams inside your own company are using MariaDB or Percona.
    Sign up for StackShare EnterpriseLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with MariaDB?
    What tools integrate with Percona?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to MariaDB and Percona?
    PostgreSQL
    PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
    MySQL
    The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
    Oracle
    Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
    MongoDB
    MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
    Cassandra
    Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
    See all alternatives