MariaDB Database Administration

Session 01: Getting, Installing, and Upgrading MariaDB

Session 02: User & Server Security

Session 03: Backing Up and Restoring Databases

Session 04: Server Monitoring & Logs

Session 05: Partitioning Tables

Session 06: MariaDB Audit Plugin

Session 07: Variables and Modes

Session 08: Copying Tables Between Different MariaDB Databases and MariaDB Servers

Detailed Syllabus:

Session 01: Getting, Installing, and Upgrading MariaDB

Where to Download MariaDB
MariaDB Binary Packages
Upgrading MariaDB
Downgrading between Major Versions of MariaDB
Compiling MariaDB From Source
Starting and Stopping MariaDB
MariaDB Performance & Advanced Configurations
Troubleshooting Installation Issues
Installing System Tables (mysql_install_db)
mysql_install_db.exe
Configuring MariaDB with Option Files
MariaDB Environment Variables
Puppet and MariaDB
MariaDB on Amazon RDS
Obsolete Installation Information
MariaDB in Microsoft Azure
mysqld Configuration Files and Groups

Session 02: User & Server Security

User Account Management
Securing MariaDB

Session 03: Backing Up and Restoring Databases

Backup and Restore Overview
Replication as a Backup Solution
mysqldump
Mariabackup
mysqlhotcopy
Percona XtraBackup

Session 04: Server Monitoring & Logs

Overview of MariaDB Logs
Error Log
Setting the Language for Error Messages
General Query Log
Slow Query Log
Rotating Logs on Unix and Linux
Binary Log
XtraDB/InnoDB Redo Log
XtraDB/InnoDB Undo Log
MyISAM Log
Transaction Coordinator Log
SQL Error Log Plugin
Writing Logs Into Tables
Performance Schema

Session 05: Partitioning Tables

Partitioning Overview
Partitioning Types
Partition Pruning and Selection
Partition Maintenance
Partitioning Limitations
Partitions Files
Partitions Metadata

Session 06: MariaDB Audit Plugin

MariaDB Audit Plugin – Installation
MariaDB Audit Plugin – Configuration
MariaDB Audit Plugin – Log Settings
MariaDB Audit Plugin – Location and Rotation of Logs
MariaDB Audit Plugin – Log Format
MariaDB Audit Plugin – Status Variables
MariaDB Audit Plugin – System Variables

Session 07: Variables and Modes

Full List of MariaDB Options, System and Status Variables
Server Status Variables
Server System Variables
OLD_MODE
SQL_MODE
SQL_MODE=MSSQL
SQL_MODE=ORACLE From MariaDB 10.3

Session 08: Copying Tables Between Different MariaDB Databases and MariaDB Servers

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.