MariaDB Database Administration Training Course

Installing MariaDB Server

• Installation on Ubuntu/Debian
• Installation across other Linux distributions
• Setup on Windows environments

MariaDB Server Files and Scripts

• MariaDB Applications
• MariaDB Server Components
• MariaDB Client Utilities
• Graphical User Interface (GUI) Tools

MariaDB Server Configuration

• Server Options Overview
• The Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• Shutdown Procedures

MariaDB Security Considerations

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

MariaDB Access Privilege System

• Overview of the MariaDB Privilege Framework
• Privileges Offered by MariaDB
• Connecting to the MariaDB Server - Phases
• 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
• Password Modification Protocols

MariaDB Database Maintenance

• Backup and Recovery Strategies
• Point-in-Time Recovery Techniques
• Maintenance and Crash Recovery Procedures
• myisamchk Syntax and Parameters
• Retrieving Table Information
• MariaDB Local Configuration Settings
• National Characters and Sorting Rules
• MariaDB Server Time Zone Settings

MariaDB Log Files

• Error Logging
• General Query Log Management
• Update Log Analysis
• Binary Log Operations
• Slow Query Log Review
• Log File Maintenance and Rotation

Running Multiple MariaDB Servers on the Same Machine

• Operating Multiple Servers on Windows
• Running Multiple Windows Servers as Services
• Operating Multiple Servers on Unix and Linux
• Utilizing Client Tools in Multi-Server Setups

MariaDB Query Cache

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

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 via 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 with Dynamic Columns
• Inserting, Updating, and Deleting Dynamic Column Data
• Retrieving Data from Dynamic Columns
• Application of Virtual Columns

Performance and Usage Statistics

• Installing the Audit Plugin
• Implementing the Audit Plugin
• Leveraging Engine-Independent Table Statistics
• Using Extended Statistics
• Enabling the Performance Schema
• Utilizing the Performance Schema

Optimizing and Tuning MariaDB

• Utilizing SHOW STATUS Commands
• Managing MariaDB Optimizer Strategies
• Using Extended Keys with InnoDB and XtraDB
• Configuring the MyISAM Segmented Key Cache
• Configuring the Threadpool
• Configuring the Aria Pagecache
• Optimizing Queries with the Subquery Cache
• Optimizing Semijoin Subqueries
• Utilizing Microseconds in DATETIME Columns
• Automating Updates for DATETIME and TIMESTAMP Columns