MariaDB Database Administration Training Course

Setting Up the MariaDB Server

• Installation on Ubuntu/Debian
• Installation on other Linux distributions
• Setup on Windows

MariaDB Server Components and Scripts

• MariaDB Applications
• MariaDB Server
• MariaDB Client
• Graphical User Interface (GUI) Tools

Configuring the MariaDB Server

• Server Options
• Server SQL Mode
• System Variables
• Dynamic System Variables
• Status Variables
• Shutdown Procedures

MariaDB Security Considerations

• Protecting MariaDB from Attacks
• Security-Specific Options
• Security Concerns Regarding LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the Privilege System
• Privileges Offered by MariaDB
• Connecting to the MariaDB Server - Phases
• Access Control, Phase 1: Connection Verification
• Access Control, Phase 2: Request Verification
• Handling Access Denied Errors

Managing MariaDB User Accounts

• Users and Passwords
• Creating New Users
• Removing User Accounts
• Restricting User Resources
• Changing Passwords

MariaDB Database Maintenance

• Backup and Recovery
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Retrieving Table Information
• MariaDB Local Settings
• National Characters and Sorting
• MariaDB Server Time Zone

MariaDB Log Files

• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Log File Maintenance and Rotation

Running Multiple MariaDB Servers on a Single Machine

• Running Multiple Servers in Windows
• Running Multiple Servers as Windows Services
• Running Multiple Servers in Unix and Linux
• Utilizing Client Tools in a Multi-Server Environment

MariaDB Query Cache

• The Concept of Query Caching
• Testing Query Cache with SELECT Statements
• Configuring the Query Cache
• Monitoring Query Cache Status and Maintenance

The CONNECT Storage Engine

• Installing the CONNECT storage engine
• Creating and dropping CONNECT tables
• Reading and writing CSV data via CONNECT
• Reading and writing XML data via CONNECT
• Accessing MariaDB tables via CONNECT
• Using the XCOL table type
• Using the PIVOT table type
• Using the OCCUR table type

Exploring Dynamic and Virtual Columns in MariaDB

• Creating tables with dynamic columns
• Inserting, updating, and deleting dynamic column data
• Reading data from a dynamic column
• Using virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Using the Audit Plugin
• Utilizing engine-independent table statistics
• Using extended statistics
• Enabling the performance schema
• Leveraging the performance schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS
• Managing MariaDB optimizer strategies
• Using extended keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Configuring the thread pool
• Configuring the Aria page cache
• Optimizing queries with the subquery cache
• Optimizing semijoin subqueries
• Using microseconds in DATETIME columns
• Auto-updating DATETIME and TIMESTAMP columns