MariaDB: The New M in LAMP
MariaDB is a branch of the popular MySQL database. The project began in 2009 circled around a storage engine, but quickly evolved to being another database, with two major releases in 2010. This session aims to introduce the project, and will help and DBA or developer get to grips with MariaDB. MariaDB is community developed, feature enhanced and backward compatible with MySQL.
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 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 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.
Speaker : Colin Charles
Colin Charles hacks on MariaDB, a MySQL fork at Monty Program Ab and advises Open Ocean Investments companies such as Web of Trust and MoSync. He lives in Kuala Lumpur. Before MySQL, he worked actively on the Fedora and OpenOffice.org projects. He’s spoken at many conferences – linux.conf.au, The MySQL Conference & Expo, foss.in, to name a few. He is currently a council member at the Malaysian National Computer Confederation (MNCC) and Technopreneurs Association of Malaysia (TeAM). He is Director at Grok Sdn Bhd.
Malaysia Open Source Conference 2011