MariaDB Database Administration Training Course

Installing the MariaDB Server

• Installation on Ubuntu/Debian
• Installation on alternative Linux distributions
• Windows installation process

MariaDB Server Components and Scripts

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

Configuring the MariaDB Server

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

MariaDB Security Considerations

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

The MariaDB Access Privilege System

• Overview of the MariaDB privilege system
• Privileges granted by MariaDB
• Connecting to the MariaDB Server: The stages involved
• Access Control, Stage 1: Verifying the connection
• Access Control, Stage 2: Verifying the request
• Handling access denied errors

Managing MariaDB User Accounts

• Handling users and passwords
• Creating new user accounts
• Removing user accounts
• Restricting user resources
• Updating passwords

MariaDB Database Maintenance

• Implementing backup and recovery solutions
• Executing Point-in-Time Recovery
• Performing maintenance and crash recovery
• Using myisamchk syntax and options
• Retrieving table information
• Configuring MariaDB local settings
• Managing national characters and sorting
• Setting the MariaDB server time zone

Reviewing MariaDB Log Files

• Inspecting the Error Log
• Reviewing the General Query Log
• Checking the Update Log
• Analyzing the Binary Log
• Monitoring the Slow Query Log
• Maintaining and rotating log files

Operating Multiple MariaDB Servers on a Single Machine

• Running multiple servers on Windows
• Running multiple Windows servers as services
• Running multiple servers on Unix and Linux systems
• Utilizing client tools in multi-server environments

Utilizing the MariaDB Query Cache

• Understanding the Query Cache concept
• Testing the Query Cache with SELECT statements
• Configuring the Query Cache
• Checking Query Cache status and performing maintenance

Utilizing the CONNECT Storage Engine

• Installing the CONNECT storage engine
• Creating and dropping CONNECT tables
• Reading and writing CSV data via CONNECT
• Reading and writing XML data via CONNECT
• Accessing MariaDB tables through CONNECT
• Applying the XCOL table type
• Applying the PIVOT table type
• Applying the OCCUR table type

Exploring Dynamic and Virtual Columns in MariaDB

• Creating tables featuring dynamic columns
• Performing insert, update, and delete operations on dynamic column data
• Retrieving data from dynamic columns
• Implementing virtual columns

Performance and Usage Statistics

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

Optimizing and Tuning MariaDB

• Using the SHOW STATUS command
• Managing MariaDB optimizer strategies
• Applying extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up the threadpool
• Configuring the Aria pagecache
• Optimizing queries utilizing the subquery cache
• Optimizing semijoin subqueries
• Using microseconds within DATETIME columns
• Automating updates for DATETIME and TIMESTAMP columns