MariaDB Database Administration Training Course

Installing the MariaDB server

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

MariaDB Server Files and Scripts

• MariaDB application binaries
• The MariaDB server process
• MariaDB client utilities
• Graphical user interface (GUI) tools

MariaDB Server Configuration

• Configuring server options
• Defining the server SQL mode
• Managing server system variables
• Handling dynamic system variables
• Monitoring server status variables
• The server shutdown procedure

MariaDB Security Considerations

• Protecting MariaDB from security threats
• Security-related configuration options
• Addressing security concerns with LOAD DATA LOCAL

The MariaDB Access Privilege System

• Overview of the MariaDB privilege framework
• Privileges granted by MariaDB
• Connecting to the MariaDB Server: Key stages
• Access Control, Stage 1: Verifying the connection
• Access Control, Stage 2: Verifying the request
• Managing access denied errors

Managing MariaDB User Accounts

• User credentials and passwords
• Creating new user accounts
• Removing user accounts
• Restricting user resource usage
• Updating passwords

MariaDB Database Maintenance

• Backup and recovery strategies
• Point-in-time recovery techniques
• Maintenance tasks and crash recovery
• myisamchk syntax and available options
• Retrieving table information
• MariaDB local settings
• National characters and sorting rules
• MariaDB server time zone configuration

MariaDB Log Files

• Error logging
• General query logging
• Update logging
• Binary logging
• Slow query logging
• Maintaining and rotating log files

Running Multiple MariaDB Servers on a Single Machine

• Deploying multiple servers on Windows
• Running multiple servers as Windows services
• Deploying 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 maintenance

The CONNECT Storage Engine

• Installing the CONNECT storage engine
• Creating and dropping CONNECT tables
• Handling CSV data via CONNECT
• Handling 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
• Inserting, updating, and deleting data in dynamic columns
• Reading data from dynamic columns
• Leveraging virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Implementing the Audit Plugin
• Utilizing engine-agnostic table statistics
• Applying extended statistics
• Activating the performance schema
• Utilizing the performance schema

Optimizing and Tuning MariaDB

• Using the SHOW STATUS command
• Managing MariaDB optimizer strategies
• Applying 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
• Incorporating microseconds in DATETIME columns
• Automating updates for DATETIME and TIMESTAMP columns