The Complete MariaDB Server Tutorial Colin Charles, Chief Evangelist, Percona Inc. [email protected] / [email protected] http://www.bytebot.net/blog/ | @bytebot on Twitter Percona Live Europe Amsterdam, Netherlands 3 October 2016 License • Creative Commons BY-NC-SA 3.0 2 whoami • Chief Evangelist (in the CTO office), Percona Inc • Founding team of MariaDB Server (2009-2016), previously at Monty Program Ab, merged with SkySQL Ab, now MariaDB Corporation • Formerly MySQL AB (exit: Sun Microsystems) • Past lives include Fedora Project (FESCO), OpenOffice.org • MySQL Community Contributor of the Year Award winner 2014 3 MariaDB is very social • facebook: fb.com/MariaDB.dbms • twitter: @MariaDB • g+: plus.google.com/+mariadb/ • Tweet things you learn with #mariadb 4 Agenda • This talk is about MariaDB Server from the MariaDB Foundation • There is no focus on MariaDB MaxScale or MariaDB ColumnStore from the MariaDB Corporation 5 Knowledgebase 6 Who are you? • Database Administrator (DBA) • Developer • Database Architect (DA) 7 Database Experience • • MySQL MariaDB • • 4.1 or earlier? 5.1 • • 5.0 5.2 • • 5.1 5.3 • • 5.5 5.5 • • 5.6 10.0 8 Understanding releases • Alpha • Beta • Release Candidate • Stable (GA) • Labs • Developer Milestone Releases (DMR) 9 What is MariaDB? • Community developed • Feature enhanced • MariaDB doesn’t depend on MySQL for development - many features are developed independently of MySQL • Backwards compatible with MySQL • (kind of) feature complete • replication supported for easy migration 10