MariaDB Database Administration Training Course

Installing MariaDB server

• Installation on Ubuntu/Debian
• Setup on Alternative Linux Distributions
• Windows Installation Process

MariaDB Server Files and Scripts

• MariaDB Software Components
• MariaDB Server Architecture
• MariaDB Client Interface
• Graphical User Interface Tools

MariaDB Server Configuration

• Configurable Server Options
• Defining the Server SQL Mode
• System Variable Management
• Dynamic Variable Adjustment
• Monitoring Server Status Variables
• Graceful Shutdown Procedures

MariaDB Security Issues

• Protecting MariaDB from Security Threats
• Implementing Security-Related Settings
• Addressing Security Risks Associated with LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the Privilege Framework
• Privileges Granted by MariaDB
• Connection Establishment Phases
• Access Control Phase 1: Connection Validation
• Access Control Phase 2: Request Validation
• Diagnosing Access Denied Errors

MariaDB User Account Management

• Managing Users and Credentials
• Provisioning New User Accounts
• Revoking User Accounts
• Enforcing Resource Limitations for Users
• Credential Rotation and Updates

MariaDB Database Maintenance

• Backup and Recovery Procedures
• Point-in-Time Recovery Strategies
• System Maintenance and Crash Resolution
• myisamchk Command Syntax and Parameters
• Retrieving Table Metadata
• Local Character Set Settings
• Handling National Characters and Sorting Rules
• Time Zone Configuration for the MariaDB Server

MariaDB Log Files

• Error Logging
• General Query Logging
• Update Logging
• Binary Logging
• Slow Query Logging
• Log File Management and Rotation

Running Multiple MariaDB Servers on the Same Machine

• Operating Multiple Instances on Windows
• Managing Windows Services for Multiple Servers
• Deploying Multiple Instances on Unix and Linux
• Utilizing Client Tools in Multi-Server Setups

MariaDB Query Cache

• Foundations of Query Caching
• Evaluating Query Cache with SELECT Statements
• Tuning Query Cache Parameters
• Monitoring Status and Maintaining the Query Cache

The CONNECT Storage Engine

• Setting up the CONNECT storage engine
• Creating and Removing CONNECT Tables
• Processing CSV Data via CONNECT
• Processing XML Data via CONNECT
• Accessing MariaDB Tables through CONNECT
• Leveraging the XCOL Table Type
• Leveraging the PIVOT Table Type
• Leveraging the OCCUR Table Type

Exploring Dynamic and Virtual Columns in MariaDB

• Defining Tables with Dynamic Columns
• Managing Data in Dynamic Columns (Insert, Update, Delete)
• Retrieving Data from Dynamic Columns
• Implementing Virtual Columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Utilizing the Audit Plugin for Logging
• Leveraging Engine-Independent Table Statistics
• Applying Extended Statistics
• Activating the Performance Schema
• Using the Performance Schema for Monitoring

Optimizing and Tuning MariaDB

• Utilizing the SHOW STATUS Command
• Guiding MariaDB Optimizer Strategies
• Employing Extended Keys with InnoDB and XtraDB
• Configuring the MyISAM Segmented Key Cache
• Setting Up the Thread Pool
• Tuning the Aria Page Cache
• Enhancing Query Performance with the Subquery Cache
• Optimizing Semijoin Subqueries
• Incorporating Microsecond Precision in DATETIME Columns
• Automating Updates for DATETIME and TIMESTAMP Columns