MariaDB Database Administration Training Course

Installing MariaDB server

• Installation on Ubuntu/Debian
• Installation 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

• Securing MariaDB against attacks
• Security-related options
• Security issues with LOAD DATA LOCAL

MariaDB Access Privilege System

• MariaDB privilege system overview
• Privileges provided by MariaDB
• Connecting to the MariaDB server – stages
• Access control, stage 1: connection verification
• Access control, stage 2: request verification
• Access denied errors

MariaDB User Account Management

• Users and passwords
• Creating new users
• Deleting user accounts
• Limiting user resources
• Changing passwords

MariaDB Database Maintenance

• Backup and recovery
• Point-in-time recovery
• Maintenance and crash recovery
• myisamchk syntax and options
• Getting table information
• MariaDB local settings
• 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

• Running multiple servers in Windows
• Running multiple servers in Windows as services
• Running multiple servers in Unix and Linux
• Using client tools in a multi-server environment

MariaDB Query Cache

• The concept of query cache
• Testing query cache with SELECT
• Configuring query cache
• Checking query cache status and maintenance

The CONNECT Storage Engine

• Installing the CONNECT storage engine
• Creating and dropping CONNECT tables
• Reading and writing CSV data using CONNECT
• Reading and writing XML data using CONNECT
• Accessing MariaDB tables using CONNECT
• Using the XCOL table type
• Using the PIVOT table type
• Using the OCCUR table type

Exploring Dynamic and Virtual Columns in MariaDB

• Creating tables with dynamic columns
• Inserting, updating, and deleting dynamic column data
• Reading data from a dynamic column
• Using virtual columns

Performance and Usage Statistics

• Installing the audit plugin
• Using the audit plugin
• Using engine-independent table statistics
• Using extended statistics
• Enabling the performance schema
• Using the performance schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS
• Controlling MariaDB optimizer strategies
• Using extended keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Configuring threadpool
• Configuring the Aria pagecache
• Optimizing queries with the subquery cache
• Optimizing semijoin subqueries
• Using microseconds in DATETIME columns
• Updating the DATETIME and TIMESTAMP columns automatically