MariaDB Database Administration Training Course

Installing the MariaDB Server

• Installation procedures for Ubuntu/Debian
• Installation on alternative Linux distributions
• Installation process on Windows

MariaDB Server Files and Scripts

• MariaDB application components
• MariaDB Server architecture
• MariaDB Client interfaces
• Graphical User Interface (GUI) utilities

Configuring the MariaDB Server

• Server configuration options
• The Server SQL Mode settings
• Server system variables
• Dynamic system variables
• Server status variables
• The shutdown process

MariaDB Security Considerations

• Protecting MariaDB from malicious attacks
• Security-specific configuration options
• Security concerns related to LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB privilege structure
• Privileges supported by MariaDB
• Stages of connecting to the MariaDB Server
• Access Control, Stage 1: Verifying the connection
• Access Control, Stage 2: Verifying the request
• Understanding access denied errors

Managing MariaDB User Accounts

• Handling users and passwords
• Creating new user accounts
• Removing user accounts
• Restricting user resource usage
• Modifying passwords

MariaDB Database Maintenance

• Backup and recovery procedures
• Point-in-Time Recovery techniques
• Maintenance tasks and crash recovery
• myisamchk syntax and available options
• Retrieving table information
• MariaDB local configuration settings
• Handling national characters and sorting
• MariaDB Server Time Zone settings

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

Operating Multiple MariaDB Servers on a Single Machine

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

The MariaDB Query Cache

• The concept behind the Query Cache
• Testing the Query Cache with SELECT statements
• Configuring the Query Cache
• Maintaining and monitoring Query Cache status

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
• Utilizing the XCOL table type
• Utilizing the PIVOT table type
• Utilizing the OCCUR table type

Investigating Dynamic and Virtual Columns in MariaDB

• Creating tables with dynamic columns
• Managing dynamic column data (insert, update, delete)
• Retrieving data from dynamic columns
• Implementing virtual columns

Performance Metrics and Usage Statistics

• Installing the Audit Plugin
• Operational use of the Audit Plugin
• Leveraging engine-independent table statistics
• Applying extended statistics
• Activating the performance schema
• Utilizing the performance schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS commands
• Managing MariaDB optimizer strategies
• Employing extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up threadpool
• Configuring the Aria pagecache
• Optimizing queries using the subquery cache
• Optimizing semijoin subqueries
• Incorporating microseconds in DATETIME columns
• Automatic updating of DATETIME and TIMESTAMP columns