MariaDB Database Administration Training Course

Installing the MariaDB Server

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

MariaDB Server Files and Scripts

• MariaDB core programs
• The MariaDB Server component
• The MariaDB Client component
• Graphical User Interface (GUI) tools

Configuring the MariaDB Server

• Server-level options
• Configuring the Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• The Shutdown process

MariaDB Security Considerations

• Securing MariaDB against potential attacks
• Security-related configuration options
• Addressing security issues associated with LOAD DATA LOCAL

The MariaDB Access Privilege System

• Overview of the MariaDB Privilege System
• Privileges granted by MariaDB
• Connecting to the MariaDB Server: Stages involved
• Access Control, Stage 1: Connection Verification
• Access Control, Stage 2: Request Verification
• Diagnosing Access Denied errors

Managing MariaDB User Accounts

• Handling Users and Passwords
• Creating new user accounts
• Removing user accounts
• Restricting user resources
• Password modification procedures

MariaDB Database Maintenance

• Backup and Recovery strategies
• Point-in-Time Recovery techniques
• Routine Maintenance and Crash Recovery
• myisamchk syntax and available options
• Retrieving Table information
• MariaDB Local settings
• National characters and sorting rules
• Configuring the MariaDB Server Time Zone

MariaDB Log Files

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

Running Multiple MariaDB Servers on a Single Machine

• Executing multiple servers on Windows
• Running multiple servers as Windows Services
• Executing multiple servers on Unix and Linux
• Utilizing client tools in a multi-server setup

The MariaDB Query Cache

• Understanding the Query Cache concept
• Testing the Query Cache with SELECT statements
• Configuring the Query Cache
• Monitoring 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 featuring dynamic columns
• Inserting, updating, and deleting data within dynamic columns
• Retrieving data from dynamic columns
• Implementing virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Operational use of the Audit Plugin
• Leveraging engine-independent table statistics
• Utilizing extended statistics
• Activating the performance schema
• Utilizing the performance schema

Optimizing and Tuning MariaDB

• Utilizing the SHOW STATUS command
• Managing MariaDB optimizer strategies
• Implementing extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up the threadpool
• Configuring the Aria pagecache
• Optimizing queries using the subquery cache
• Optimizing semijoin subqueries
• Incorporating microseconds in DATETIME columns
• Automating updates for DATETIME and TIMESTAMP columns