Lynda - Advanced Topics in MySQL and MariaDB | 152MB
Genre: eLearning | Level: Advanced | Language: English
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.
* 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