Advanced MySQL and MariaDB

Learn how to perform a variety of advanced administration tasks in both MariaDB and MySQL, two powerful database solutions that work in slightly different ways.

Introduction

• Welcome
• What you should know before watching this course

1. How MariaDB Is Different

• How MariaDB is different than MySQL
• Exploring server thread pooling
• Viewing user statistics
• Creating and using virtual columns
• Using persistent virtual columns
• Progress reporting and millisecond resolution

2. The Sphinx Storage Engine

• Installing the Sphinx storage engine
• Creating a Sphinx table

3. NoSQL Integration

• Installing the HandlerSocket plugin
• Configuring HandlerSocket

4. Global Transaction Identifiers and Multisource Replication

• Global transaction identifiers (GTIDs) and failover
• Setting up GTIDs in MySQL
• Setting up GTIDs in MariaDB
• Exploring multisource replication

5. Audit Plugin

• Understanding and installing the Audit plugin
• Using MariaDB audit logging
• Using MySQL audit logging

6. Authentication Plugin

• Understanding and installing the Authentication plugin
• Using the Pluggable Authentication Modules (PAM)

7. Geometric and Geographical Data

• Storing geometric and geographical data
• Using GIS in MySQL
• Using GIS in MariaDB

Conclusion

• Next steps