MariaDB Database Administration Training Course

Installing the MariaDB Server

• Deployment on Ubuntu/Debian
• Setup on alternative Linux distributions
• Installation on the Windows platform

MariaDB Server Files and Scripts

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

MariaDB Server Configuration

• Configuring Server Options
• Defining the Server SQL Mode
• Managing Server System Variables
• Handling Dynamic System Variables
• Monitoring Server Status Variables
• Understanding the Shutdown Process

MariaDB Security Considerations

• Protecting MariaDB Against Security Threats
• Implementing Security-Related Options
• Addressing Security Risks Associated with LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB Privilege Framework
• Types of Privileges Granted by MariaDB
• Stages of Connecting to the MariaDB Server
• Access Control, Stage 1: Verifying Connections
• Access Control, Stage 2: Validating Requests
• Diagnosing Access Denied Errors

MariaDB User Account Administration

• Managing Users and Passwords
• Provisioning New User Accounts
• Removing User Accounts
• Setting Resource Limits for Users
• Updating Passwords

MariaDB Database Maintenance

• Implementing Backup and Recovery Solutions
• Executing Point-in-Time Recovery
• Performing Maintenance and Crash Recovery
• Applying myisamchk Syntax and Options
• Retrieving Table Metadata
• Configuring MariaDB Local Settings
• Handling National Characters and Sorting Rules
• Setting the MariaDB Server Time Zone

MariaDB Log Management

• Reviewing the Error Log
• Analyzing the General Query Log
• Examining the Update Log
• Inspecting the Binary Log
• Monitoring the Slow Query Log
• Maintaining and Rotating Log Files

Operating Multiple MariaDB Instances on a Single Machine

• Running Multiple Servers on Windows
• Deploying Multiple Servers as Windows Services
• Managing Multiple Servers on Unix and Linux
• Utilizing Client Tools in Multi-Server Environments

MariaDB Query Caching

• Understanding the Query Cache Concept
• Testing Query Cache Performance with SELECT Statements
• Configuring Query Cache Parameters
• Monitoring Query Cache Status and Performing Maintenance

Utilizing 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 Native MariaDB Tables Using CONNECT
• Leveraging the XCOL Table Type
• Implementing the PIVOT Table Type
• Applying the OCCUR Table Type

Investigating 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
• Incorporating Virtual Columns

Performance Metrics and Usage Statistics

• Installing the Audit Plugin
• Operationalizing the Audit Plugin
• Leveraging Engine-Independent Table Statistics
• Utilizing Extended Statistics
• Activating the Performance Schema
• Interpreting the Performance Schema

MariaDB Optimization and Tuning

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