MariaDB 10 Feature Overview

New Features
12 November 2:50pm - 3:40pm @ Orchard 2
Experience level: 
Intermediate
Duration: 
50 minutes conference
MariaDB is now three years old and we've made 5 major GA releases of the popular database software. With many Linux distributions taking the path to replace MySQL with MariaDB, it can be said that it is 2013 that MariaDB has arrived (so a little longer than OpenOffice.org/LibreOffice split). With MariaDB, you have many new features that you can utilize to take your database usage to the next level. This isn't a run thru of them, but common features that benefit production DBAs. Learn: * How to use subqueries with MariaDB as it materialises them * Get closed-source features open now: PAM authentication for everyone * How the threadpool benefits your short running web-based queries * Why is group commit in the binary log helpful to you? * How can you make your queries faster using the non-blocking client library? How do you integrate this with Node.js? * How full-text search works alongside Sphinx * About GIS functionality, and how we are at OpenGIS specifications * Integration with a Cassandra cluster * NoSQL inside of MariaDB * Embedding using the LGPL C/Java connectors * Using the CONNECT engine to join data between Oracle and Cassandra for example * Use the SPIDER storage engine for automatic sharding The session will be packed with practical examples on why MariaDB is amazing and the feature-set that is currently larger than MySQL. Documentation at the Knowledgebase is fine & dandy, but practical solutions is what is presented here.


Speakers

Chief Evangelist, MariaDB
Biography: 
Colin Charles works on MariaDB at SkySQL. He has been the Chief Evangelist for MariaDB since 2009, work ranging from speaking engagements to consultancy and engineering works around MariaDB. He lives in Kuala Lumpur, Malaysia and had worked at MySQL since 2005, and been a MySQL user since 2000. Before joining MySQL, he worked actively on the Fedora and OpenOffice.org projects. He's well known on the conference track having spoken at many of them over the course of his career.