DevNation 2014 - Colin Charles - MariaDB for DevOps
MariaDB, the MySQL alternative shipped in many a Linux distribution, includes a lot of new features that DevOps can take advantage of. In this practical overview (this is not a hands on session - demos performed by the presenter), the attendee as a DevOps practitioner will learn to take advantage of the new MariaDB features over what is currently available in MySQL. Some highlights include: * Using authentication plugins, like PAM, and turning on two-factor authentication * Using & managing various storage engines in your queries: SphinxSE for full-text search, connecting to a Cassandra cluster, making use of ODBC & other various data sources via CONNECT (eg. joining data from Microsoft SQL Server with MariaDB is entirely possible), and automatic sharding in the database via SPIDER. (backup strategies, deployment, network, etc. are all covered) * Using the threadpool for your unpredictable workload when you end up on Hacker News/Slashdot/etc. * Taking advantage of new replication features like group commit, parallel replication, crash-safe slaves, multi-source replication and more * Using the non-blocking client library for your daily maintenance tasks or just writing faster node.js-based applications * KILL all queries for a running user * Using SQL Roles and how to manage them * Using EXPLAIN and the extensions that are shipped * Making use of changed client utilities, as well as new ones like my top * Taking advantage of extensions to INFORMATION_SCHEMA and gleaning statistics from there * Using GIS (2D), spatial types and sorting out your mapping needs including practical examples like parsing GPX data files (natively or via the CONNECT engine) * Using regular expressions with PCRE extensions * Management with MariaDB Manager API and the RESTful interface * Using it in the cloud, including on OpenShift If you are a MySQL DBA or developer, you will learn what differences MariaDB offers and how you can make use of these options in your deployment.