MariaDB Database Administration Training Course

Installing MariaDB server

• Installation on Ubuntu/Debian
• Deployment on other Linux distributions
• Setting up the installation on Windows

MariaDB Server Files and Scripts

• MariaDB applications
• The MariaDB server component
• The MariaDB client component
• Graphical User Interface (GUI) tools

MariaDB Server Configuration

• Configuring server options
• Understanding the server SQL mode
• Working with server system variables
• Managing dynamic system variables
• Reviewing server status variables
• The server shutdown process

MariaDB Security Issues

• Protecting MariaDB against potential attacks
• Security-focused configuration options
• Addressing security concerns related to LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB privilege system
• Privileges granted by MariaDB
• Stages of connecting to the MariaDB server
• Access control, Stage 1: Verifying the connection
• Access control, Stage 2: Verifying the request
• Diagnosing access denied errors

MariaDB User Account Management

• Managing users and passwords
• Creating new user accounts
• Removing user accounts
• Setting limits on user resources
• Updating user passwords

MariaDB Database Maintenance

• Backup and recovery procedures
• Point-in-time recovery techniques
• Maintenance and crash recovery strategies
• myisamchk syntax and available options
• Retrieving table information
• Configuring MariaDB local settings
• Handling national characters and sorting
• Setting 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 the Same Machine

• Operating multiple servers on Windows
• Running multiple servers as Windows services
• Managing multiple servers on Unix and Linux systems
• Utilising client tools in a multi-server setup

MariaDB Query Cache

• The underlying concept of the query cache
• 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 removing CONNECT tables
• Reading and writing CSV data via CONNECT
• Reading and writing XML data via CONNECT
• Accessing MariaDB tables through CONNECT
• Utilising the XCOL table type
• Utilising the PIVOT table type
• Utilising the OCCUR table type

Exploring Dynamic and Virtual Columns in MariaDB

• Creating tables incorporating dynamic columns
• Inserting, updating, and deleting data in dynamic columns
• Reading data from a dynamic column
• Implementing virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Utilising the Audit Plugin
• Working with engine-independent table statistics
• Applying extended statistics
• Enabling the performance schema
• Using the performance schema

Optimizing and Tuning MariaDB

• Utilising SHOW STATUS
• Controlling MariaDB optimizer strategies
• Employing extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up the threadpool
• Configuring the Aria pagecache
• Optimising queries using the subquery cache
• Optimising semijoin subqueries
• Utilising microseconds in DATETIME columns
• Automatic updates for DATETIME and TIMESTAMP columns