MariaDB Database Administration Training Course

Installing the MariaDB Server

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

MariaDB Server Components and Scripts

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

Configuring the MariaDB Server

• Configuring server options
• Understanding the server SQL mode
• Managing server system variables
• Handling dynamic system variables
• Monitoring server status variables
• The shutdown process

MariaDB Security Considerations

• Protecting MariaDB from potential attacks
• Configuring security-related options
• Addressing security concerns with LOAD DATA LOCAL

The MariaDB Access Privilege System

• Overview of the MariaDB privilege framework
• Privileges granted by MariaDB
• Connection stages to the MariaDB Server
• Access Control Stage 1: Connection validation
• Access Control Stage 2: Request validation
• Diagnosing access denied errors

Managing MariaDB User Accounts

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

MariaDB Database Maintenance

• Backup and recovery procedures
• Point-in-time recovery techniques
• Maintenance and crash recovery
• Syntax and options for myisamchk
• Retrieving table information
• MariaDB local configuration
• National character sets and sorting
• MariaDB server time zones

MariaDB Log Management

• 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
• Utilizing client tools in multi-server setups

MariaDB Query Caching

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

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

Exploring Dynamic and Virtual Columns in MariaDB

• Creating tables with dynamic columns
• Inserting, updating, and deleting dynamic column data
• Retrieving data from dynamic columns
• Utilizing virtual columns

Performance and Usage Metrics

• Installing the Audit Plugin
• Utilizing the Audit Plugin
• Using engine-independent table statistics
• Leveraging extended statistics
• Enabling the performance schema
• Utilizing the performance schema

Optimizing and Tuning MariaDB

• Using SHOW STATUS commands
• 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 using the subquery cache
• Optimizing semijoin subqueries
• Using microseconds in DATETIME columns
• Automatically updating DATETIME and TIMESTAMP columns