2014
Lynda
Sheeri Cabral
1:39
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.
Introduction
3m 6s
Welcome
1m 14s
What you should know before watching this course
1m 52s
1. How MariaDB Is Different
30m 29s
How MariaDB is different than MySQL
4m 54s
Exploring server thread pooling
5m 22s
Viewing user statistics
6m 43s
Creating and using virtual columns
3m 56s
Using persistent virtual columns
5m 45s
Progress reporting and millisecond resolution
3m 49s
2. The Sphinx Storage Engine
8m 37s
Installing the Sphinx storage engine
3m 31s
Creating a Sphinx table
5m 6s
3. NoSQL Integration
8m 57s
Installing the HandlerSocket plugin
3m 39s
Configuring HandlerSocket
5m 18s
4. Global Transaction Identifiers and Multisource Replication
16m 20s
Global transaction identifiers (GTIDs) and failover
2m 47s
Setting up GTIDs in MySQL
4m 58s
Setting up GTIDs in MariaDB
5m 36s
Exploring multisource replication
2m 59s
5. Audit Plugin
12m 33s
Understanding and installing the Audit plugin
3m 8s
Using MariaDB audit logging
4m 28s
Using MySQL audit logging
4m 57s
6. Authentication Plugin
8m 26s
Understanding and installing the Authentication plugin
4m 49s
Using the Pluggable Authentication Modules (PAM)
3m 37s
7. Geometric and Geographical Data
9m 44s
Storing geometric and geographical data
1m 54s
Using GIS in MySQL
5m 5s
Using GIS in MariaDB
2m 45s
Conclusion
1m 28s
Next steps
1m 28s
lynda.com/MariaDB-tutorials/Advanced-Topics-MySQL-MariaDB/175635-2.html
Download File Size:145.87 MB
|
