MariaDB Database Administration Training Course

Setting Up the MariaDB Server

• Installation on Ubuntu/Debian systems
• Installation across other Linux distributions
• Deployment on Windows environments

MariaDB Server Files and Scripts

• Overview of MariaDB programs
• MariaDB Server components
• MariaDB Client tools
• GUI-based utilities

MariaDB Server Configuration

• Configuring server options
• Understanding the Server SQL Mode
• Managing Server System Variables
• Handling Dynamic System Variables
• Monitoring Server Status Variables
• Managing the Shutdown Process

MariaDB Security Considerations

• Implementing defenses against potential attacks
• Reviewing security-related configuration options
• Addressing security risks associated with LOAD DATA LOCAL

MariaDB Access Privilege System

• High-level overview of the MariaDB Privilege System
• Privileges granted by MariaDB
• Stages involved in connecting to the MariaDB Server
• Access Control, Stage 1: Connection Verification
• Access Control, Stage 2: Request Verification
• Interpreting Access Denied Errors

MariaDB User Account Management

• Managing Users and Passwords
• Procedure for Creating New Users
• Process for Deleting User Accounts
• Restricting User Resource Usage
• Updating Passwords

MariaDB Database Maintenance

• Strategies for Backup and Recovery
• Implementing Point-in-Time Recovery
• Maintenance and Crash Recovery procedures
• myisamchk Syntax and available options
• Retrieving Table Information
• MariaDB Local Settings
• Handling National Characters and Sorting
• MariaDB Server Time Zone configuration

MariaDB Log Files

• Error Log analysis
• General Query Log review
• Update Log management
• Binary Log inspection
• Slow Query Log analysis
• Maintaining and Rotating Log Files

Operating Multiple MariaDB Instances on a Single Host

• Running multiple servers in a Windows environment
• Configuring multiple servers as Windows services
• Deploying multiple servers on Unix and Linux platforms
• Utilizing Client Tools in a Multi-Server setup

MariaDB Query Cache

• Fundamentals of the Query Cache concept
• Testing Query Cache performance with SELECT statements
• Configuration of 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 through 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 that include dynamic columns
• Performing insert, update, and delete operations on dynamic column data
• Retrieving data from dynamic columns
• Implementing virtual columns

Performance and Usage Statistics

• Installation of the Audit Plugin
• Application of the Audit Plugin
• Leveraging engine-independent table statistics
• Utilizing extended statistics
• Activation of the performance schema
• Practical use of the performance schema

Optimization and Tuning of MariaDB

• Utilizing SHOW STATUS commands
• Managing MariaDB optimizer strategies
• Implementing extended Keys with InnoDB and XtraDB
• Configuration of the MyISAM segmented key cache
• Setup and configuration of threadpool
• Configuration of the Aria pagecache
• Optimizing queries utilizing the subquery cache
• Optimization of semijoin subqueries
• Incorporating microseconds in DATETIME columns
• Automatic updating of DATETIME and TIMESTAMP columns