Overview
-
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.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- 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
- Installing the Sphinx storage engine
- Creating a Sphinx table
- Installing the HandlerSocket plugin
- Configuring HandlerSocket
- Global transaction identifiers (GTIDs) and failover
- Setting up GTIDs in MySQL
- Setting up GTIDs in MariaDB
- Exploring multisource replication
- Understanding and installing the Audit plugin
- Using MariaDB audit logging
- Using MySQL audit logging
- Understanding and installing the Authentication plugin
- Using the Pluggable Authentication Modules (PAM)
- Storing geometric and geographical data
- Using GIS in MySQL
- Using GIS in MariaDB
- Next steps
