MariaDB Database Administration Training Course

Installing MariaDB Server

• Deployment on Ubuntu/Debian
• Installation on Other Linux Distributions
• Setup on Windows

MariaDB Server Files and Scripts

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

MariaDB Server Configuration

• Server Configuration Options
• Defining the Server SQL Mode
• Managing Server System Variables
• Dynamic System Variables
• Server Status Variables
• Shutdown Procedures

MariaDB Security Considerations

• Protecting MariaDB from Attacks
• Security-Related Configuration Options
• Security Risks Associated with LOAD DATA LOCAL

MariaDB Access Privilege System

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

MariaDB User Account Management

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

MariaDB Database Maintenance

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

MariaDB Log Files

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

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
• Utilizing Client Tools in a Multi-Server Setup

MariaDB Query Cache

• Understanding the Query Cache Concept
• 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 Removing CONNECT Tables
• Reading and Writing CSV Data via CONNECT
• Reading and Writing XML Data via CONNECT
• Accessing MariaDB Tables via 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 Dynamic Column Data
• Retrieving Data from Dynamic Columns
• Working with Virtual Columns

Performance and Usage Metrics

• Installing the Audit Plugin
• Operating the Audit Plugin
• Utilizing Engine-Independent Table Statistics
• Employing Extended Statistics
• Activating the Performance Schema
• Applying the Performance Schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS Commands
• Managing MariaDB Optimizer Strategies
• Leveraging Extended Keys with InnoDB and XtraDB
• Configuring the MyISAM Segmented Key Cache
• Configuring Thread Pooling
• Configuring the Aria Page Cache
• Optimizing Queries with the Subquery Cache
• Optimizing Semijoin Subqueries
• Using Microsecond Precision in DATETIME Columns
• Automatically Updating DATETIME and TIMESTAMP Columns