You are here

MariaDB 10 is the nexus for open source database innovation in the Cloud age. It delivers greater agility, cost-effective scale and high performance to developers

MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application compatible with MySQL®, it adds many new capabilities to address the most challenging web and enterprise application use cases.

Since its launch in 2010, MariaDB has emerged as an active and vibrant open source community leading the way in database innovation. Engineered by some of the world’s leading database experts including the founder of MySQL, Michael ‘Monty’ Widenius, MariaDB has been enthusiastically adopted by a fast-growing eco-system which includes web-scale leaders like Red Hat, Wikipedia and Taobao.

If you're building serious, revenue-generating applications using MariaDB, MariaDB Enterprise's certified binaries, tooling and professional expertise is all you need to make your project successful. Need easy high availability? Check out MariaDB Enterprise Cluster.

MariaDB 10 can be downloaded free from MariaDB.org (Linux and Windows), installed straight from your Linux repository (Red Hat, Fedora, Suse and Debian) or hosted on Amazon Web Services (AWS).

Scaling for the Cloud

Massive, incremental scalability is just one of the critical attributes of successful online web-scale applications. In addition, near-continuous availability, iron-clad security, real-time performance, guaranteed data consistency, and rapid development agility are all requirements across many applications and vertical markets.

MariaDB addresses scalability and availability through clustering technologies that replicate data across many servers, which in turn work to eliminate single points of failure and distribute the load across more resources.

The Cloud allows companies to provision and manage all these servers to maximize flexibility and reduce costs, and MariaDB fits right in. We are working with cloud and cloud stack providers to insure wide scale availability in both public and private clouds.

MariaDB vs. MySQL

MySQL is the most widely adopted database technology for enterprise and web applications in the world. It has proven to be a flexible, powerful, and cost-effective alternative to proprietary databases, and MySQL technology is central to the architecture of the Internet. MariaDB 10 builds on that legacy with enhancements designed to handle even more complex database challenges born of today’s fast-moving, web-scale, always-on mobile Internet.

 

Compare Products MySQL 5.6 MariaDB 10
What is it? MySQL 5.6 is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack. MariaDB 10 is a enhanced, high performance, free and open source alternative to MySQL that helps the world's busiest websites deliver more content faster.
Scalability
Parallel Slave Replication [moreScalability
Compatible with MySQL 5.6 but with improvements. MySQL's parallel replication can only run transactions for different databases in parallel - each database per slave is single-threaded. The MariaDB implementation can run multiple transactions within same database in parallel. Up to 4x replication performance improvement vs. MySQL. See technical documentation.
]
Single threaded per database  
Multi-source Replication [moreScalability
Allows a slave database server to replicate from multiple master servers. If you've split your data over several masters - multiple databases, applications, sharding - Multi-source Replication can pull all the data together onto one slave for analytics, backup, etc. See technical documentation.
]
   
Global Transaction ID [moreScalability
Makes complex replication hierarchies such as Multi-Source Replication be ACID consistent and durable, while running in parallel at high performance and scale. Tags events within a replication hierarchy with a unique, universal identifier spanning multiple domains, but strictly ordered within each domain. MySQL 5.6’s GTID does not allow for independent domains, and thus is limited in supporting complex replication. MariaDB’s GTID is more powerful and flexible. See technical documentation.
]
Limited  
Sharding - Spider Storage Engine [moreScalability
Spider is a storage engine contributed by a 3rd party. It allows for a table to be sharded using simple hashing only. Supports XA transactions. Shards may be replicated for HA. Includes master lookup table replication. See technical documentation.
]
3rd party  
TokuDB Storage Engine [moreScalability
Integrated with MariaDB 10, TokuDB uses advanced indexing and compression that allows for much faster updates/insertion, greatly reducing slave lag for replication. See technical documentation.
]
3rd party  
Table Partitioning: Improvements [moreScalability
Application-level table partitioning lets an application control how a table is split across multiple OS files and multiple servers, for performance and scale.
]
   
Performance
TokuDB Storage Engine [morePerformance
Integrated with MariaDB 10, TokuDB uses advanced indexing and compression that allows for up to 20x faster updates/insertion, and up to 90% less HDD/flash. See technical documentation.
]
3rd party  
Engine Independent Table Statistics [morePerformance
Improves optimizations by gathering statistics for use by the optimizer about the size and structure of tables, independent of specific storage engine features. See technical documentation.
]
   
Subquery Optimizations [morePerformance
Through transformation, apply existing optimizations to a broader range of SQL statements. See technical documentation.
]
   
Histogram Stats for Non-Indexed Columns [morePerformance
Improves optimizations on columns without indexes, by capturing the distribution of values on such columns and using that distribution to adjust the query plan. See technical documentation.
]
   
Fusion-io specific enhancements [morePerformance
Improves the performance of Fusion-io SSDs when used with MariaDB. Uses the atomic write feature of the Fusion-io directFS filesystem, and eliminates InnoDB overhead to guarantee ACID consistency. See technical documentation.
]
   
Performance Schema [morePerformance
Allows a developer or DBA, or IT automation tooling to directly monitor performance of a database node in real time through SQL queries to a monitoring table built right into the system.
]
   
Improved thread pool [morePerformance
Increase the scalability of the database server when there are many concurrent connections. See technical documentation.
]
MySQL Enterprise only  
NoSQL Capabilities
CONNECT storage engine [moreNoSQL Capabilities
CONNECT is a flexible tool to access diverse data sources dynamically, including unstructured files such as log files in a folder, or any database with an ODBC connector, from within MariaDB. See technical documentation.
]
   
Sequence storage engine [moreNoSQL Capabilities
Create numerical sequences that are stored in memory and can be used in your queries. See technical documentation.
]
   
NoSQL Cassandra Storage Engine [moreNoSQL Capabilities
Combine data from Cassandra with your data in MariaDB, read and write Cassandra data, and connect many MariaDB servers to one Cassandra ring, creating a high-availability cluster. See technical documentation.
]
   
Dynamic Columns [moreNoSQL Capabilities
Dynamic Columns store different, labeled data objects in each row of a table in much the same way as NoSQL technologies. See technical documentation.
]
   
NoSQL Handlersocket interface [moreNoSQL Capabilities
HandlerSocket gives you direct access to InnoDB/XtraDB and SPIDER. See technical documentation.
]
   
NoSQL memcache interface [moreNoSQL Capabilities
Persist memcached data in InnoDB.
]
   
Operations
Improved table discovery [moreOperations
For storage engines that support this capability, MariaDB 10 includes the ability to use tables for which no explicit CREATE TABLE statement has been run. The Sequence and FederatedX storage engines now support table discovery. See technical documentation.
]
   
SHOW PLUGINS SONAME [moreOperations
Reports information and installation status on compiled-in and dynamic plug-ins. See technical documentation.
]
   
SHUTDOWN Command [moreOperations
Added SHUTDOWN statement to SQL syntax - shuts a server down gracefully. Same permissions as mysqladmin shutdown. See technical documentation.
]
   
Kill query by query ID [moreOperations
Allows a DBA or admin to kill a single query executing on a connection/thread, without killing the entire connection. See technical documentation.
]
   
SHOW EXPLAIN Command [moreOperations
Helps developers and DBAs diagnose performance issues. Lets you get the query plan for actively running queries. Optionally, can automatically run SHOW EXPLAIN on queries in the slow query log and capture the plan in the log. See technical documentation.
]
   
Per-thread Memory Statistics [moreOperations
Adds a memory usage column to the processlist, and allows this value to be returned through SHOW STATUS. Using this new feature, DBAs and developers can evaluate per-connection memory usage to diagnose problems.
]
   
Improved Error Messages [moreOperations
All errors now include descriptive text in the log for the benefit of both developers and DBAs.
]
   
Online ALTER TABLE [moreOperations
Do many of your schema changes without interrupting the system. MySQL 5.6 introduces the concept of online ALTER, which has been merged to MariaDB 10.0.
]
   
Security & Compliance
Role-based access control [moreSecurity & Compliance
DBAs can now create roles with certain permissions and assign users to the roles. See technical documentation.
]
   
Audit Plugin [moreSecurity & Compliance
The MariaDB Audit Plugin introduces the capabilities of tracking user access to data. Follow in real time who’s doing what in your databases. See technical documentation.
]
MySQL Enterprise only  
PAM Authentication Plugin [moreSecurity & Compliance
The plugin enables Pluggable Authentication Modules (PAM) for the database server, which is an authentication framework used by Linux, FreeBSD, Solaris, and other operating systems. See technical documentation.
]
MySQL Enterprise only  

SUBSCRIBE TO GET MARIADB TIPS AND NEWS UPDATES IN YOUR INBOX