Advanced MySQL and MariaDB

Go to class
Write Review

Free Online Course: Advanced MySQL and MariaDB provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Advanced MySQL and MariaDB is taught by Sheeri Cabral.

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
    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