MariaDB Database Administration Training Course

Installing the MariaDB Server

• Installation on Ubuntu/Debian
• Installation on alternative Linux distributions
• Setup on Windows platforms

MariaDB Server Components and Scripts

• MariaDB Software Binaries
• MariaDB Server Instance
• MariaDB Client Applications
• Graphical User Interface (GUI) Utilities

MariaDB Server Configuration Settings

• Server Configuration Options
• Defining the Server SQL Mode
• Static Server System Variables
• Modifiable System Variables
• Server Status Metrics
• Graceful Shutdown Procedures

MariaDB Security Considerations

• Mitigating MariaDB Vulnerabilities and Attacks
• Configuration Options for Security
• Addressing Security Risks Associated with LOAD DATA LOCAL

MariaDB Access Control System

• Overview of the MariaDB Privilege Hierarchy
• Permissions Granted by MariaDB
• Client-Server Connection Phases
• Access Control Phase 1: Validating the Connection
• Access Control Phase 2: Verifying Requests
• Diagnosing Access Denied Errors

Managing MariaDB User Accounts

• User Credentials and Password Policies
• Provisioning New Users
• Revoking User Accounts
• Enforcing Resource Limits for Users
• Modifying Account Passwords

MariaDB Database Upkeep and Maintenance

• Data Backup and Restoration Workflows
• Point-in-Time Recovery Techniques
• System Maintenance and Crash Recovery
• myisamchk Command Syntax and Flags
• Retrieving Table Metadata and Information
• MariaDB Locale Settings
• Character Sets and Collation Sorting
• Server Time Zone Configuration

MariaDB Log File Management

• Error Logs
• General Query Logs
• Update Logs
• Binary Logs
• Slow Query Logs
• Log File Archiving and Rotation Strategies

Deploying Multiple MariaDB Instances on a Single Host

• Running Concurrent Servers on Windows
• Managing Multiple Servers as Windows Services
• Running Concurrent Servers on Unix and Linux
• Leveraging Client Tools in Multi-Server Setups

MariaDB Query Caching

• Understanding the Query Cache Architecture
• Validating Query Cache with SELECT Statements
• Tuning Query Cache Parameters
• Monitoring Query Cache Health and Maintenance

The CONNECT Storage Engine

• Deploying the CONNECT storage engine
• Creating and Removing CONNECT Tables
• Processing CSV Data via CONNECT
• Processing XML Data via CONNECT
• Querying 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

• Defining Tables with Dynamic Columns
• CUDA Operations on Dynamic Column Data
• Retrieving Data from Dynamic Columns
• Implementing Virtual Columns

Performance Metrics and Usage Analytics

• Deploying the Audit Plugin
• Implementing the Audit Plugin for Compliance
• Leveraging Engine-Independent Table Statistics
• Utilizing Extended Statistics
• Activating the Performance Schema
• Analyzing Data via the Performance Schema

MariaDB Optimization and Tuning

• Analyzing Server Health with SHOW STATUS
• Directing MariaDB Optimizer Strategies
• Implementing Extended Keys with InnoDB and XtraDB
• Configuring the MyISAM Segmented Key Cache
• Configuring the Thread Pool
• Configuring the Aria Page Cache
• Enhancing Query Efficiency with the Subquery Cache
• Optimizing Semijoin Subqueries
• Utilizing Microsecond Precision in DATETIME Fields
• Automating Updates for DATETIME and TIMESTAMP Fields