MariaDB Database Administration Training Course

Installing the MariaDB server

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

MariaDB Server Components and Scripts

• Core MariaDB software applications
• MariaDB server infrastructure
• MariaDB client interfaces
• Graphical user interface (GUI) utilities

MariaDB Server Configuration

• Server configuration parameters
• Defining the server SQL operational mode
• Static server system variables
• Dynamic system variable management
• Monitoring server status indicators
• Managing the graceful shutdown sequence

MariaDB Security Considerations

• Hardening MariaDB against unauthorized access
• Configuring security-specific options
• Mitigating risks associated with LOAD DATA LOCAL operations

MariaDB Access Privilege Framework

• Overview of the MariaDB privilege architecture
• Permissions granted by the MariaDB engine
• Phases of establishing a connection to the MariaDB server
• Access control phase one: Validating the connection request
• Access control phase two: Verifying command privileges
• Handling access denial exceptions

MariaDB User Account Administration

• Managing user identities and credential security
• Provisioning new user accounts
• Revoking user accounts
• Restricting user resource allocation
• Updating user passwords

MariaDB Database Maintenance

• Backup strategies and restoration procedures
• Implementing point-in-time recovery
• Routine maintenance and post-failure recovery
• myisamchk command syntax and parameters
• Retrieving detailed table metadata
• Configuring MariaDB local settings
• Handling character sets and collation rules
• Managing the MariaDB server time zone

MariaDB Logging Mechanisms

• Error log management
• General query logging
• Update log maintenance
• Binary log operations
• Slow query log analysis
• Maintaining and rotating log files

Operating Multiple MariaDB Instances on a Single Host

• Running concurrent servers on Windows environments
• Managing concurrent servers as Windows services
• Running concurrent servers on Unix and Linux platforms
• Utilizing client tools in multi-instance configurations

MariaDB Query Caching

• Understanding the query cache concept
• Testing cache effectiveness with SELECT operations
• Configuring query cache parameters
• Monitoring cache status and performing maintenance

The CONNECT Storage Engine

• Installing the CONNECT storage engine module
• Creating and removing CONNECT table structures
• Processing CSV data via CONNECT
• Processing XML data via CONNECT
• Accessing MariaDB tables through the CONNECT engine
• Applying the XCOL table format
• Applying the PIVOT table format
• Applying the OCCUR table format

Dynamic and Virtual Columns in MariaDB

• Defining tables with dynamic column structures
• Modifying data within dynamic columns
• Retrieving data from dynamic column fields
• Implementing virtual columns

Performance and Usage Metrics

• Installing the audit plugin component
• Utilizing the audit plugin for monitoring
• Leveraging engine-agnostic table statistics
• Employing extended statistical metrics
• Activating the performance schema
• Utilizing the performance schema for analysis

MariaDB Optimization and Tuning

• Utilizing the SHOW STATUS command
• Directing MariaDB optimizer algorithms
• Implementing extended keys in InnoDB and XtraDB
• Configuring the MyISAM segmented key cache
• Configuring thread pool settings
• Configuring the Aria page cache
• Optimizing queries via the subquery cache
• Optimizing semijoin subquery execution
• Utilizing microsecond precision in DATETIME fields
• Automating updates for DATETIME and TIMESTAMP fields