Duration
MARIADB DATABASE ADMINISTRATION
5 days
AUDIENCE
- System Administrators
- Consultant
- Junior Database Administrators
PREREQUISITES
- Linux Administration Experience
- Windows Administration
METHODOLOGY
This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.
COURSE OBJECTIVES
At the end of the MariaDB Database Administration course, delegates will have the knowledge to use all the features available to administer, monitor and support MariaDB 10.1 and 10.2 databases and servers.
Introduction
- An Overview of MariaDB Architecture
- MySQL Server
- MySQL Tools
- MySQL Admin
Module 2: MySQL Workbench
- Installation
- Connecting
- Screens
Module 3: Obtaining Metadata
- What is Metadata?
- The MySQL show Client Program
- The SHOW and DESCRIBE Command
- The Information Schema
Module 4: MariaDB Server Installation and Configuration
- MariaDB Distributions
- Installing on Windows
- Installing on Linux
- Starting and Stopping on Windows
- Status Files
- Upgrading the Server
- Time Zone Tables
Module 5: Configuring the Server
- MariaDB Server Options and Variables
- MariaDB Status Variables
- Configuring MySQL Enterprise Audit
Module 6: SQL Modes, Log Files and Binary Logging
- MySQL Error Messages
- The SHOW Errors Statement
- The SHOW Warnings Statement
- SQL Modes
- Note Messages
- The PERROR Utility
- The General Log
- The Error Log
- The Slow Query Log
Module 7: MariaDB Architecture
- Client/Server Overview
- Communication Protocols
- The SQL Parser and Storage Engine Tiers
- How MariaDB Uses Disk Space
- How MariaDB Uses Memory
Module 8: Transactions and Locking
- Locking Concepts
- Explicit Table Locking
- Advisory Locking
Module 9: Table Maintenance
- Table Maintenance Operations
- Check Table
- Repair Table
- Analyze Table
- Optimize Table
- MySQL Check
Module 10: Backup and Recovery
- Designing a Backup and Recovery Strategy
- The Advantages and Disadvantages of Different Backup Methods
- Binary Backups of MYISAM Tables
- Binary Backups of Innodb Tables
- Recovery
- Import and Export Operations
Introduction
- User Accounts
- Creating Users
- Renaming Users
- Changing Passwords
- Dropping Users
- Granting Privileges
- The User Table
Introduction
- Types of Privileges
- Revoking Privileges
- Resource Limits
- The MySQL Database
Module 13: Security and Upgrades
- Signs of Poor Security
- Security Risks
- Users, Operating System, File System and Network Security
- Using SSL With MySQL
- Remote Connecting to the MySQL Server Using SSH
Module 14: Tuning and Indexes
- Indexes for Performance
- Creating and Dropping Indexes
- Obtaining Index Metadata
- Indexing Principles
Module 15: Tuning the Server
- Status Variables
- Server Variables
- Performance Schema Overview
- The Query Cache
Module 16: The Event Scheduler
- Event scheduler concepts
- Event scheduler configuration
- Creating, altering and dropping events
- Event scheduler monitoring
- Events and privileges
Module 17: Overview of High Availability
- High Availability Goals
- High Availability Concepts
- Design for High Availability
- Definition of Availability
- High Availability Terminology
Module 18: Configure Master Slave Replication
- Replication Overview
- When to Use Replication
- Testing Replication
- Excluding Databases or Tables from Replication
- Example: Setting Up a Master Slave Replication Using GTIDs
- Controlled Switchover
Programme scope, delivery arrangements and suitability are confirmed during enquiry.