Advanced MySQL and MariaDB

1h 40mAdvanced2014-10-21

Authors

Sheeri Cabral

Former Oracle ACE Director for MySQL, Founder of Technocation

Course details

MySQL and MariaDB are powerful database solutions that operate in slightly different ways. In this course Sheeri K. Cabral compares and contrasts MySQL and MariaDB, and shows you how to perform advanced tasks in each system. First, learn how to install and configure the Sphinx storage engine and HandlerSocket plugin. Then find out how to set up GTIDs (global transaction identifiers) and make replication even easier, especially for failover. Finally, discover how to install and use authentication and audit plugins, and learn how MySQL and MariaDB store geometric and geographical information. These tutorials will help you evaluate these database management systems and find useful new tools and techniques to add to your administrative arsenal.

Learning objectives
Comparing MariaDB and MySQL
Creating and using virtual columns in MariaDB
Building Sphinx tables
Installing HandlerSocket
Setting up GTIDs in MariaDB and MySQL
Audit logging in MariaDB and MySQL
Using GIS in MariaDB and MySQL

Skills covered

MariaDBMySQLAdvancedDatabase DevelopmentDatabase ManagementOpen SourceSoftware Development

Concepts

0. Introduction

01 - Welcome
02 - What you should know before watching this course

1. How MariaDB Is Different

03 - How MariaDB is different than MySQL
04 - Exploring server thread pooling
05 - Viewing user statistics
06 - Creating and using virtual columns
07 - Using persistent virtual columns
08 - Progress reporting and millisecond resolution

2. The Sphinx Storage Engine

09 - Installing the Sphinx storage engine
10 - Creating a Sphinx table

3. NoSQL Integration

11 - Installing the HandlerSocket plugin
12 - Configuring HandlerSocket

4. Global Transaction Identifiers and Multisource Replication

13 - Global transaction identifiers (GTIDs) and failover
14 - Setting up GTIDs in MySQL
15 - Setting up GTIDs in MariaDB
16 - Exploring multisource replication

5. Audit Plugin

17 - Understanding and installing the Audit plugin
18 - Using MariaDB audit logging
19 - Using MySQL audit logging

6. Authentication Plugin

20 - Understanding and installing the Authentication plugin
21 - Using the Pluggable Authentication Modules (PAM)

7. Geometric and Geographical Data

22 - Storing geometric and geographical data
23 - Using GIS in MySQL
24 - Using GIS in MariaDB

Conclusion

25 - Next steps