MariaDB: The New M in LAMPColin Charles
MariaDB started life as a database to host the Maria 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 MySQL, 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 had two major releases.
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.
Specific focus areas: * improved optimiser that helps execute queries faster * focus on different storage engines (Aria, XtraDB, PBXT, FederatedX, OQGRAPH, SphinxSE) * pool of threads support, table elimination, virtual columns, dynamic columns, extended user statistics, segmented key caches * pluggable authentication * more!