MariaDB Database Administration Training Course

Installing the MariaDB server

• Installation on Ubuntu/Debian
• Installation on alternative Linux Distributions
• Installation on Windows

MariaDB Server Files and Scripts

• MariaDB Programs
• MariaDB Server
• MariaDB Client
• Graphical User Interface (GUI) Tools

MariaDB Server Configuration

• Server Options
• Defining the Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• The Shutdown Procedure

MariaDB Security Considerations

• Protecting MariaDB from Attacks
• Security-Related Configuration Options
• Security Implications of LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB Privilege System
• Privileges Granted by MariaDB
• Connection Phases to the MariaDB Server
• Access Control, Phase 1: Verifying Connections
• Access Control, Phase 2: Verifying Requests
• Handling Access Denied Errors

MariaDB User Account Management

• Managing Users and Passwords
• Provisioning New Users
• Removing User Accounts
• Restricting User Resources
• Modifying Passwords

MariaDB Database Maintenance

• Backup and Recovery Procedures
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Retrieving Table Information
• MariaDB Local Settings
• National Characters and Sorting Order
• MariaDB Server Time Zone

MariaDB Log Files

• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Maintenance and Rotation of Log Files

Running Multiple MariaDB Servers on a Single Machine

• Running Multiple Servers on Windows
• Running Multiple Servers on Windows as Services
• Running 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 with SELECT Statements
• Configuring the Query Cache
• Monitoring and Maintaining 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

Exploring Dynamic and Virtual Columns in MariaDB

• Creating tables featuring dynamic columns
• Inserting, updating, and deleting dynamic column data
• Retrieving data from a dynamic column
• Implementing virtual columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Utilizing 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
• Managing MariaDB optimizer strategies
• Implementing extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Configuring threadpool
• Configuring the Aria pagecache
• Optimizing queries using the subquery cache
• Optimizing semijoin subqueries
• Utilizing microseconds in DATETIME columns
• Automatically updating DATETIME and TIMESTAMP columns