MariaDB Database Administration Training Course

Installing the MariaDB Server

• Installation on Ubuntu and Debian systems
• Deployment on other Linux distributions
• Setup procedures for Windows environments

MariaDB Server Components and Scripts

• Overview of MariaDB programs
• Core MariaDB Server components
• MariaDB Client utilities
• Graphical User Interface (GUI) tools

Configuring the MariaDB Server

• Managing server options
• Understanding the Server SQL Mode
• Working with Server System Variables
• Utilizing Dynamic System Variables
• Monitoring Server Status Variables
• The server shutdown process

MariaDB Security Considerations

• Strategies to secure MariaDB against potential attacks
• Implementing security-related options
• Addressing security issues associated with LOAD DATA LOCAL

The MariaDB Access Privilege System

• Overview of the MariaDB Privilege System
• Specific privileges granted by MariaDB
• Stages of connecting to the MariaDB Server
• Access Control, Stage 1: Verifying the connection
• Access Control, Stage 2: Verifying requests
• Handling Access Denied errors

Managing MariaDB User Accounts

• Managing 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
• General maintenance and crash recovery
• myisamchk syntax and available options
• Retrieving table information
• MariaDB local settings
• Handling national characters and sorting
• 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

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

The MariaDB Query Cache

• Understanding the concept of Query Cache
• Testing Query Cache performance with SELECT statements
• Configuration of the Query Cache
• Checking status and maintaining the Query Cache

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 using the CONNECT engine
• Utilizing the XCOL table type
• Applying the PIVOT table type
• Using the OCCUR table type

Dynamic and Virtual Columns in MariaDB

• Creating tables that include dynamic columns
• Inserting, updating, and deleting data in dynamic columns
• Retrieving data from dynamic columns
• Implementing virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Utilizing the Audit Plugin
• Employing engine-independent table statistics
• Using extended statistics
• Enabling the performance schema
• Leveraging the performance schema

Optimizing and Tuning MariaDB

• Utilizing the SHOW STATUS command
• Controlling MariaDB optimizer strategies
• Using 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
• Automatic updates for DATETIME and TIMESTAMP columns