MySQL Database Administration Exam Objective

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: MariaDB Replication

Session 09: MariaDB Galera Cluster

Session 10: Optimization and Tuning

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: MariaDB Replication

Replication Overview
Replication Commands
Setting Up Replication
Setting up a Replication Slave with Mariabackup
Replication as a Backup Solution
Multi-Source Replication
Replication Threads
Global Transaction ID
Parallel Replication
Replication and Binary Log System Variables
Replication and Binary Log Status Variables
Binary Log
Unsafe Statements for Statement-based Replication
Replication and Foreign Keys
Relay Log
Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT
Group Commit for the Binary Log
Selectively Skipping Replication of Binlog Events
Binlog Event Checksums
Binlog Event Checksum Interoperability
Annotate_rows_log_event
Row-based Replication With No Primary Key
Replication Filters
Running Triggers on the Slave for Row-based Events
Semisynchronous Replication
Using MariaDB Replication with MariaDB Galera Cluster
Compressing Events to Reduce Size of the Binary Log
Delayed Replication
Replication When the Master and Slave Have Different Table Definitions
Restricting speed of reading binlog from master by a slave
Obsolete Replication Information
Changing a slave to become the master
Replication with Secure Connections

Session 09: MariaDB Galera Cluster

What is MariaDB Galera Cluster?
About Galera Replication
Galera Use Cases
MariaDB Galera Cluster – Known Limitations
Tips on Converting to Galera
Getting Started with MariaDB Galera Cluster
Configuring MariaDB Galera Cluster
State Snapshot Transfers (SSTs) in Galera Cluster
Galera Cluster Status Variables
Galera Cluster System Variables
Building the Galera wsrep Package on Ubuntu and Debian
Building the Galera wsrep Package on Fedora
Installing Galera from Source
Galera Test Repositories
wsrep_provider_options
Galera Cluster Address
Galera Load Balancer
MariaDB Galera Cluster Releases
Upgrading Galera Cluster
Using MariaDB Replication with MariaDB Galera Cluster
Securing Communications in Galera Cluster

Session 10: Optimization and Tuning

Hardware Optimization
Operating System Optimizations
Optimization and Indexes
Query Optimizations
Optimizing Tables
System Variables
Buffers, Caches and Threads
Optimizing Data Structure
MariaDB Internal Optimizations
Benchmarking
Compression

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.