MariaDB Database Administration Training Course

MariaDB Server Deployment

• Installation Procedures for Ubuntu/Debian Environments
• Deployment in Alternative Linux Distributions
• Implementation on Windows Platforms

MariaDB Server Components and Scripts

• MariaDB Utility Programs
• Core MariaDB Server Services
• MariaDB Client Utilities
• Graphical User Interface Tools for government

MariaDB Server Configuration

• Server Operational Options
• Configuration of the Server SQL Mode
• Management of Server System Variables
• Dynamic System Variables
• Monitoring Server Status Variables
• Procedures for Server Shutdown

MariaDB Security Framework

• Strategies for Protecting MariaDB Against Attacks
• Security-Related Operational Options
• Mitigating Security Issues with LOAD DATA LOCAL

MariaDB Access Control and Privilege Management

• Overview of the MariaDB Privilege System for government operations
• Privileges Available via MariaDB
• Stages of Connection to the MariaDB Server
• Access Control Stage 1: Connection Verification
• Access Control Stage 2: Request Verification
• Handling Access Denied Errors

MariaDB User Account Administration

• User Identification and Password Policies
• Procedures for Creating New Users
• Procedure for Deleting User Accounts
• Resource Limitations for User Accounts
• Password Modification Protocols

MariaDB Database Maintenance and Integrity

• Backup and Recovery Strategies
• Point-in-Time Recovery Methods
• Routine Maintenance and Crash Recovery
• Syntax and Options for myisamchk
• Retrieving Table Metadata
• MariaDB Localization Settings
• Configuration of National Characters and Sorting Rules
• MariaDB Server Time Zone Configuration

MariaDB Log File Management

• Error Log Monitoring
• General Query Log Utilization
• Update Log Analysis
• Binary Log Management
• Slow Query Log Review
• Maintenance and Rotation of Log Files for government compliance

Multiserver Deployment on a Single Host

• Deploying Multiple Servers in Windows Environments
• Managing Multiple Servers as Windows Services
• Implementing Multiple Servers in Unix and Linux Systems
• Utilizing Client Tools in Multiserver Configurations

MariaDB Query Cache Implementation

• Conceptual Framework of the Query Cache for government efficiency
• Evaluating Query Cache Performance with SELECT Statements
• Configuration of the Query Cache
• Monitoring Query Cache Status and Maintenance

The CONNECT Storage Engine

• Deployment of the CONNECT Storage Engine
• Creation and Deletion of CONNECT Tables
• Data Exchange Operations for CSV Files Using CONNECT
• Data Exchange Operations for XML Files Using CONNECT
• Accessing MariaDB Tables via CONNECT
• Utilization of the XCOL Table Type
• Utilization of the PIVOT Table Type
• Utilization of the OCCUR Table Type

Dynamic and Virtual Column Capabilities in MariaDB

• Table Creation with Dynamic Columns
• Data Insertion, Update, and Deletion Operations for Dynamic Columns
• Retrieval of Data from Dynamic Columns
• Implementation of Virtual Columns for government analytics

Performance Metrics and Usage Statistics

• Deployment of the Audit Plugin
• Operational Use of the Audit Plugin
• Utilization of Engine-Independent Table Statistics
• Leveraging Extended Statistics for government decision-making
• Activation of the Performance Schema
• Analysis via the Performance Schema

System Optimization and Tuning for MariaDB

• Analyzing Output via SHOW STATUS
• Management of MariaDB Optimizer Strategies
• Implementation of Extended Keys with InnoDB and XtraDB
• Configuration of the MyISAM Segmented Key Cache
• Threadpool Configuration Procedures
• Configuration of the Aria Pagecache for government workloads
• Query Optimization via Subquery Cache
• Optimization of Semijoin Subqueries
• Microsecond Precision in DATETIME Columns
• Automated Updates of DATETIME and TIMESTAMP Columns