MariaDB: The New M in LAMP

MariaDB: The New M in LAMP

Par Colin Charles
Date : samedi 24 septembre 2011 16h30
Durée : 45 minutes
Langue : English
Tags : database mariadb mysql opensource

MariaDB started life as a database to host the Maria (now renamed Aria) storage engine in 2009. Not long after its inception, the MySQL community went through yet another change in ownership, and it was deemed that MariaDB will be a complete database branch developed to extend MySQ, but with constant merging of upstream changes.

The goal of the MariaDB project is to ensure that everyone is part of the community, including employees of the major steering companies. MariaDB also features enhanced features, some of which are common with the Percona Performance Server. Most importantly, MariaDB is a drop-in replacement and is completely backward compatible with MySQL. In 2010, MariaDB released 5.1 in February, and 5.2 in November - two major releases in a span of one calendar year is a feat that was achieved!

Specific focus areas of the talk will include:
* why MariaDB executes queries faster -- all thanks to its improved optimiser
* the focus of different engines and why with MariaDB/MySQL, knowing which engine to pick, really makes a difference to your workload. MariaDB includes Aria, XtraDB, PBXT, FederatedX, OQGRAPH, SphinxSE and there are more to come
* new features like pool of threads support, table elimination, virtual columns, extended user statistics, segmented key cache
* why plugin's are utilised in MariaDB, and how to make use of pluggable authentication (PAM, LDAP, etc.) amongst other things
* why testing your database is important -- MariaDB has more coverage testing
* getting involved with the MariaDB project
* how features like

An overview of future features like Batched Key Access and GIS functionality will also be covered briefly.

DBAs and developers alike will gain an introduction to MariaDB, what is different with MySQL, how to make use of the feature enhancements, and more.