Loading...

How to MariaDB The New in LAMP, Colin Charles @ T-DOSE

702 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Nov 5, 2011

http://www.citytv.nl

Colin Charles @ T-DOSE The place where experts meet on 5 and 6 November 2011, Eindhoven 2011, Eindhoven.

Colin Charles works at Monty Program Ab, on MariaDB, and Open Ocean Investments on Web of Trust, and MoSync. He lives in Kuala Lumpur, Malaysia and had worked at MySQL since 2005. Before joining 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 was Program Chair for the O'Reilly MySQL Conference & Expo 2008-2011.

MariaDB: The New M in LAMP

Author: Colin Charles

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! MariaDB 5.3 is currently in beta.

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
* looking at cool new features like progress reporting, for starters
* getting involved with the MariaDB project

An overview of future features like 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.

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...