MariaDB Database Administration Training Course

Installing MariaDB Server

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

MariaDB Server Files and Scripts

• MariaDB Programs
• MariaDB Server Components
• MariaDB Client Tools
• Graphical User Interface (GUI) Tools

MariaDB Server Configuration

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

MariaDB Security Issues

• Protecting MariaDB Against Security Attacks
• Security-Related Configuration Options
• Security Considerations for LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB Privilege System
• Privileges Granted by MariaDB
• Connecting to the MariaDB Server: Connection Stages
• Access Control, Stage 1: Verifying the Connection
• Access Control, Stage 2: Verifying the Request
• Handling Access Denied Errors

MariaDB User Account Management

• Managing Users and Passwords
• Creating New User Accounts
• Removing User Accounts
• Limiting User Resources
• Changing User Passwords

MariaDB Database Maintenance

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

MariaDB Log Files

• Error Log Management
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Maintaining and Rotating Log Files

Running Multiple MariaDB Servers on the Same Machine

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

MariaDB Query Cache

• Understanding the Query Cache Concept
• Testing Query Cache with SELECT Statements
• Configuring the Query Cache
• Checking Query Cache Status and Performing 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 Using CONNECT
• Utilizing the XCOL Table Type
• Utilizing the PIVOT Table Type
• Utilizing the OCCUR Table Type

Exploring Dynamic and Virtual Columns in MariaDB

• Creating Tables with Dynamic Columns
• Inserting, Updating, and Deleting Data in Dynamic Columns
• Reading Data from Dynamic Columns
• Implementing Virtual Columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Utilizing the Audit Plugin
• Using Engine-Independent Table Statistics
• Leveraging Extended Statistics
• Enabling the Performance Schema
• Utilizing the Performance Schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS Commands
• Controlling 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 Using the Subquery Cache
• Optimizing Semijoin Subqueries
• Using Microseconds in DATETIME Columns
• Automatic Updates for DATETIME and TIMESTAMP Columns