MariaDB Database Administration Training Course

Installing MariaDB server

• Deployment on Ubuntu/Debian
• Setup on other Linux Distributions
• Installation on Windows

MariaDB Server Files and Scripts

• MariaDB Programs
• MariaDB Server
• MariaDB Client
• GUI Tools

MariaDB Server Configuration

• Server Options
• The Server SQL Mode
• Server System Variables
• Dynamic System Variables
• Server Status Variables
• Shutdown Process

MariaDB Security Issues

• Protecting MariaDB from Attacks
• Security-Related Options
• Security Considerations for LOAD DATA LOCAL

MariaDB Access Privilege System

• Overview of the MariaDB Privilege System
• Privileges Offered by MariaDB
• Connecting to the MariaDB Server - Phases
• Access Control, Phase 1: Connection Verification
• Access Control, Phase 2: Request Verification
• Handling Access Denied Errors

MariaDB User Account Management

• Users and Passwords
• Creating New Users
• Removing User Accounts
• Constraining User Resources
• Updating Passwords

MariaDB Database Maintenance

• Backup and Recovery
• Point-in-Time Recovery
• Maintenance and Crash Recovery
• myisamchk Syntax and Options
• Retrieving Table Information
• MariaDB Local Setting
• National Characters and Sorting
• MariaDB Server Time Zone

MariaDB Log Files

• Error Log
• General Query Log
• Update Log
• Binary Log
• Slow Query Log
• Log File Maintenance and Rotation

Running Multiple MariaDB Servers on the Same Machine

• Executing Multiple Servers in Windows
• Managing Multiple Servers in Windows as Services
• Running Multiple Servers in Unix and Linux
• Utilizing Client Tools in a Multi-Server Environment

MariaDB Query Cache

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

The CONNECT Storage Engine

• Setting up the CONNECT storage engine
• Managing CONNECT tables
• Handling CSV data via CONNECT
• Handling XML data via CONNECT
• Accessing MariaDB tables using CONNECT
• Applying the XCOL table type
• Applying the PIVOT table type
• Applying the OCCUR table type

Exploring Dynamic and Virtual Columns in MariaDB

• Generating tables with dynamic columns
• Modifying dynamic column data
• Retrieving data from a dynamic column
• Leveraging virtual columns

Performance and Usage Statistics

• Deploying the Audit Plugin
• Operating the Audit Plugin
• Utilizing engine-independent table statistics
• Applying extended statistics
• Activating the performance schema
• Utilizing the performance schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS
• Managing MariaDB optimizer strategies
• Employing extended Keys with InnoDB and XtraDB
• Setting up the MyISAM segmented key cache
• Configuring threadpool
• Configuring the Aria pagecache
• Enhancing queries with the subquery cache
• Optimizing semijoin subqueries
• Incorporating microseconds in DATETIME columns
• Auto-updating DATETIME and TIMESTAMP columns