MariaDB Database Administration Training Course

Installing the MariaDB server

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

MariaDB Server Components and Scripts

• MariaDB Applications
• MariaDB Server Architecture
• MariaDB Client Interfaces
• Graphical User Interface Tools

MariaDB Server Configuration

• Server Option Settings
• Defining the Server SQL Mode
• Configuring Server System Variables
• Managing Dynamic System Variables
• Monitoring Server Status Variables
• The Shutdown Procedure

MariaDB Security Considerations

• Protecting MariaDB from Security Threats
• Implementing Security-Related Options
• Addressing Security Concerns with LOAD DATA LOCAL

MariaDB Access Privilege Framework

• Overview of the MariaDB Privilege System
• Permissions Granted by MariaDB
• Connection Phases to the MariaDB Server
• Access Control Phase 1: Validating Connections
• Access Control Phase 2: Verifying Requests
• Handling Access Denied Errors

Managing MariaDB User Accounts

• Managing Users and Passwords
• Provisioning New Users
• Removing User Accounts
• Restricting User Resources
• Password Modification Procedures

MariaDB Database Upkeep

• Backup and Restoration Protocols
• Point-in-Time Recovery Techniques
• Maintenance Tasks and Crash Recovery
• myisamchk Command Syntax and Parameters
• 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
• Examining the General Query Log
• Analyzing the Update Log
• Inspecting the Binary Log
• Monitoring the Slow Query Log
• Maintaining and Rotating Log Files

Operationalizing Multiple MariaDB Instances on a Single Host

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

MariaDB Query Caching

• Fundamentals of Query Caching
• Validating Query Cache via SELECT Statements
• Setting Up Query Cache
• Monitoring Query Cache State and Upkeep

The CONNECT Storage Engine

• Deploying the CONNECT storage engine
• Creating and removing CONNECT tables
• Reading and writing CSV data via CONNECT
• Reading and writing XML data via CONNECT
• Accessing 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

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

Performance Metrics and Usage Analytics

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

Optimization and Tuning of MariaDB

• Utilizing SHOW STATUS
• Directing MariaDB optimizer strategies
• Employing extended Keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up threadpool
• Configuring the Aria pagecache
• Enhancing query performance with the subquery cache
• Optimizing semijoin subqueries
• Utilizing microseconds in DATETIME fields
• Automatic updates for DATETIME and TIMESTAMP fields