MariaDB Database Administration Training Course

Installing MariaDB Server

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

MariaDB Server Files and Scripts

• MariaDB executable programs
• Core server components
• Client utilities
• Graphical user interface (GUI) tools

MariaDB Server Configuration

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

MariaDB Security Issues

• Protecting MariaDB from potential attacks
• Configuring security-related options
• Addressing security concerns with LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB privilege architecture
• Types of privileges supported by MariaDB
• Connecting to the server: Step-by-step stages
• Access Control, Stage 1: Verifying connections
• Access Control, Stage 2: Verifying requests
• Understanding access denied errors

MariaDB User Account Management

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

MariaDB Database Maintenance

• Implementing backup and recovery strategies
• Performing point-in-time recovery
• Regular maintenance and crash recovery procedures
• Syntax and options for myisamchk
• Retrieving detailed table information
• Configuring MariaDB local settings
• Handling national characters and sorting rules
• Setting the MariaDB server time zone

MariaDB Log Files

• Interpreting the error log
• Reviewing the general query log
• Analyzing the update log
• Examining the binary log
• Monitoring the slow query log
• Maintaining and rotating log files

Running Multiple MariaDB Servers on the Same Machine

• Hosting multiple servers on Windows
• Configuring multiple servers as Windows services
• Deploying multiple servers on Unix and Linux
• Utilizing client tools in a multi-server setup

MariaDB Query Cache

• Understanding the query cache concept
• Testing query cache efficiency with SELECT statements
• Configuring query cache parameters
• Checking cache status and performing 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 native MariaDB tables using CONNECT
• Utilizing the XCOL table type
• Applying the PIVOT table type
• Using 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
• Reading data from dynamic columns
• Leveraging virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Implementing the Audit Plugin
• Utilizing engine-independent table statistics
• Applying extended statistics
• Enabling the performance schema
• Using the performance schema for monitoring

Optimizing and Tuning MariaDB

• Leveraging the SHOW STATUS command
• Controlling MariaDB optimizer strategies
• Utilizing extended keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up the thread pool
• Configuring the Aria page cache
• Optimizing queries using the subquery cache
• Optimizing semijoin subqueries
• Utilizing microseconds in DATETIME columns
• Automating updates for DATETIME and TIMESTAMP columns