MariaDB Database Administration Training Course

Installing the MariaDB Server

• Installation on Ubuntu/Debian
• Deployment on other Linux distributions
• Setting up on Windows

MariaDB Server Components and Scripts

• MariaDB applications
• MariaDB server engine
• MariaDB client utilities
• Graphical User Interface (GUI) tools

Configuring the MariaDB Server

• Server configuration options
• Defining the Server SQL Mode
• Managing Server System Variables
• Handling Dynamic System Variables
• Monitoring Server Status Variables
• Managing the Shutdown Process

Addressing MariaDB Security Concerns

• Protecting MariaDB from potential attacks
• Configuring security-related parameters
• Managing security risks associated with LOAD DATA LOCAL

The MariaDB Access Privilege Framework

• Overview of the MariaDB Privilege System
• Privileges granted by MariaDB
• Connecting to the MariaDB Server: Process Stages
• Access Control Stage 1: Validating Connections
• Access Control Stage 2: Verifying Requests
• Handling Access Denied errors

Managing MariaDB User Accounts

• User credentials and passwords
• Provisioning new user accounts
• Removing user accounts
• Restricting user resource usage
• Updating password credentials

MariaDB Database Upkeep

• Backup and recovery strategies
• Executing Point-in-Time Recovery
• Maintenance tasks and crash recovery
• Syntax and options for myisamchk
• Retrieving table metadata
• Local settings in MariaDB
• Handling national characters and sorting orders
• Setting the MariaDB Server Time Zone

MariaDB Log Files

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

Host Multiple MariaDB Servers on a Single Machine

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

The MariaDB Query Cache

• Understanding the Query Cache concept
• Testing Query Cache performance with SELECT statements
• Configuring the Query Cache
• Monitoring status and maintaining the Query Cache

The CONNECT Storage Engine

• Setting up the CONNECT storage engine
• Creating and dropping CONNECT tables
• Reading and writing CSV data via CONNECT
• Reading and writing XML data via CONNECT
• Accessing MariaDB tables through CONNECT
• Leveraging the XCOL table type
• Leveraging the PIVOT table type
• Leveraging the OCCUR table type

Investigating Dynamic and Virtual Columns in MariaDB

• Building 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 Statistics

• Installing the Audit Plugin
• Implementing the Audit Plugin
• Utilizing engine-independent table statistics
• Applying extended statistics
• Activating the performance schema
• Utilizing the performance schema

Optimization and Tuning of MariaDB

• Utilizing SHOW STATUS commands
• Managing MariaDB optimizer strategies
• Applying extended keys with InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Configuring the thread pool
• Configuring the Aria page cache
• Optimizing queries using the subquery cache
• Optimizing semijoin subqueries
• Utilizing microseconds within DATETIME columns
• Automatic updating of DATETIME and TIMESTAMP columns