MariaDB Database Administration Training Course

Installing the MariaDB server

• Installation on Ubuntu/Debian
• Installation on other Linux Distributions
• Installation on Windows

MariaDB Server Files and Scripts

• MariaDB Program Suite
• MariaDB Server Component
• MariaDB Client Tools
• Graphical User Interface (GUI) Utilities

Configuring the MariaDB Server

• Server Configuration Options
• The Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• The Shutdown Procedure

MariaDB Security Considerations

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

MariaDB Access Privilege Framework

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

MariaDB User Account Oversight

• Managing Users and Passwords
• Creating New User Accounts
• Removing User Accounts
• Restricting User Resources
• Updating Passwords

MariaDB Database Upkeep

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

MariaDB Log Files

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

Operating Multiple MariaDB Servers on a Single Machine

• Running Multiple Servers on Windows
• Running Multiple Servers as Windows Services
• Running Multiple Servers on Unix and Linux
• Utilising Client Tools in a Multi-Server Setup

MariaDB Query Cache

• The Query Cache Concept
• Testing the Query Cache with SELECT Statements
• Setting Up the Query Cache
• Monitoring Query Cache Status and Maintenance

The CONNECT Storage Engine

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

Investigating Dynamic and Virtual Columns in MariaDB

• Creating tables with dynamic columns
• Inserting, modifying, and removing dynamic column data
• Reading data from a dynamic column
• Utilising virtual columns

Performance and Usage Metrics

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

Optimising and Tuning MariaDB

• Using SHOW STATUS
• Controlling MariaDB Optimiser Strategies
• Using extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Configuring threadpool
• Configuring the Aria pagecache
• Optimising queries with the subquery cache
• Optimising semijoin subqueries
• Using microseconds in DATETIME columns
• Automatically updating DATETIME and TIMESTAMP columns