MariaDB Database Administration Training Course

Installing the MariaDB Server

• Installation on Ubuntu/Debian systems
• Installation on alternative Linux distributions
• Deployment on Windows platforms

MariaDB Server Files and Scripts

• MariaDB application programs
• MariaDB server components
• MariaDB client utilities
• Graphical user interface (GUI) tools

Configuring the MariaDB Server

• Server option settings
• Understanding the Server SQL Mode
• Server system variables
• Dynamic system variables
• Server status variables
• The shutdown procedure

Addressing MariaDB Security Concerns

• Protecting MariaDB from potential attacks
• Security-specific configuration options
• Security considerations regarding LOAD DATA LOCAL

The MariaDB Access Privilege System

• Overview of the MariaDB privilege framework
• Privileges offered by MariaDB
• Steps involved in connecting to the MariaDB Server
• Access Control, Stage 1: Connection verification
• Access Control, Stage 2: Request verification
• Handling access denied errors

Managing MariaDB User Accounts

• Handling users and passwords
• Creating new user accounts
• Removing user accounts
• Restricting user resources
• Updating passwords

Maintaining the MariaDB Database

• Backup and recovery processes
• Point-in-Time Recovery
• Maintenance and crash recovery procedures
• myisamchk syntax and options
• Retrieving table information
• MariaDB local configuration settings
• Handling national characters and sorting
• MariaDB server time zone settings

Managing MariaDB Log Files

• Error logs
• General query logs
• Update logs
• Binary logs
• Slow query logs
• Maintaining and rotating log files

Operating Multiple MariaDB Servers on a Single Machine

• Running multiple servers on Windows
• Running multiple Windows servers as services
• Running multiple servers on Unix and Linux environments
• Utilizing client tools in a multi-server setup

The MariaDB Query Cache

• Fundamentals of the Query Cache concept
• Testing the Query Cache with SELECT statements
• Configuring the Query Cache
• Monitoring Query Cache status and performing maintenance

Using 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 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 that include dynamic columns
• Inserting, updating, and deleting dynamic column data
• Retrieving data from dynamic columns
• Implementing virtual columns

Monitoring Performance and Usage Statistics

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

Optimizing and Tuning MariaDB

• Applying the SHOW STATUS command
• Managing MariaDB optimizer strategies
• Utilizing extended keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Setting up the threadpool
• Configuring the Aria pagecache
• Optimizing queries via the subquery cache
• Optimizing semijoin subqueries
• Incorporating microseconds in DATETIME columns
• Automatically updating DATETIME and TIMESTAMP columns