MariaDB is an open source relational database. It is an enhanced, drop-in replacement for MySQL. MariaDB is a robust, scalable, and reliable SQL server that maintains high compatibility with MySQL, ensuring a "drop-in" replacement capability with library binary equivalency and exact matching with MySQL APIs and commands.
It includes the XtraDB storage engine as a replacement for InnoDB, as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL.
In addition to the standard MyISAM, BLACKHOLE, CSV, MEMORY, and ARCHIVE storage engines, the following are also included with MariaDB Source and Binary packages:
MySQL compatibility features include:
Download MariaDB 5.5.33a: http://bit.ly/16lmpYo
It includes the XtraDB storage engine as a replacement for InnoDB, as well as a new storage engine, Aria, that intends to be both a transactional and non-transactional engine perhaps even included in future versions of MySQL.
In addition to the standard MyISAM, BLACKHOLE, CSV, MEMORY, and ARCHIVE storage engines, the following are also included with MariaDB Source and Binary packages:
- Aria
- XtraDB (drop-in replacement for InnoDB)
- PBXT (In MariaDB 5.1, MariaDB 5.2, and MariaDB 5.3. Disabled in MariaDB 5.5.)
- FederatedX (drop-in replacement for Federated)
- OQGRAPH (In MariaDB 5.1, MariaDB 5.2, and MariaDB 5.3. Disabled in MariaDB 5.5.) — new in 5.2
- SphinxSE — new in 5.2
- IBMDB2I. Oracle removed this in MySQL 5.1.55 but we have kept the code in MariaDB until the version 5.5.
- Cassandra in MariaDB-10.0
- We are working on adding other no-sql storage engines into MariaDB.
- CONNECT in MariaDB-10.0
- SEQUENCE in MariaDB-10.0
MySQL compatibility features include:
- Data and table definition files (.frm) files are binary compatible.
- All client APIs, protocols and structs are identical.
- All filenames, binaries, paths, ports, sockets, and etc... should be the same.
- All MySQL connectors (PHP, Perl, Python, Java, .NET, MyODBC, Ruby, MySQL C connector etc) work unchanged with MariaDB.
- There are some installation issues with PHP5 that you should be aware of (a bug in how the old PHP5 client checks library compatibility).
- The mysql-client package also works with MariaDB server.
- The shared client library is binary compatible with MySQL's client library.
Download MariaDB 5.5.33a: http://bit.ly/16lmpYo
MariaDB vs. MySQL: A Comparison
RSS Feed