TreeHouse Python Testing
TreeHouse Python Testing
April 30, 2018
Lynda CSS: Flexbox First Look
Lynda CSS: Flexbox First Look
May 1, 2018
Lynda Advanced Topics in MySQL and MariaDB

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.
Want more information about MariaDB? Check out Understanding MariaDB for MySQL Users.
Topics include:
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


AuthorSheeri Cabral
Duration1h 39m
File siza149 MB


Lynda Advanced Topics in MySQL and MariaDB