MySQL Database Administration Training
Level
BeginnerDuration
24h / 3 daysDate
Individually arrangedPrice
Individually arrangedMySQL Database Administration Training
The MySQL Database Administration training is focused on learning how to manage and maintain database systems based on MySQL. Participants will gain knowledge about installing, configuring, and monitoring a MySQL server; managing users and permissions; performing backups and restoring data; optimizing performance; and troubleshooting database-related issues. The training includes practical exercises so that participants can acquire skills necessary to effectively manage MySQL databases in a variety of application environments.
Requirements
- Basic knowledge of Linux, SSH configuration, and scripting fundamentals
- Choice of one of the database engines
Work Environment
- Containerization
- 2-3 virtual machines running Linux (recommended)
What will you learn?
- Participants will learn both basic and some intermediate topics related to MySQL and MariaDB administration. They will practice managing users, performing backups, and optimizing databases via choosing appropriate storage engines and memory configurations. High-availability topics will also be covered, including setting up clusters and configuring master-worker replication.
Who is this training for?
Anyone who wants to learn the basics of MySQL (or similar systems such as Percona, MariaDB) administration-
Those whose roles include administrator, DevOps, or Site Reliability Engineer
Training Program
-
Introduction
- Components of MySQL
- MySQL installation
- Configuration files
-
File Structures and Engines
- Overview of file structure
- Table storage engines
- Creating tables with a chosen engine
-
Server Configuration
- Global server configuration
- User session settings
- Database-level verification
- Using SHOW GLOBAL and SET commands
-
Memory Management
- Memory configuration
- Session buffer
- Global buffer
- Engine buffer
- Query cache
-
Permissions
- Creating and removing users
- Managing permissions
-
Transactions
- Isolation levels
- Data locks
- Managing and verifying active transactions
- Overview of performance_schema
-
Tables and Partitions
- Creating and dropping partitions
- Temporary tables
-
Backups
- Exporting databases
- Server-level exports
- Exporting individual objects
- Types of backups
- Using XtraBackup tool
- Restoring databases
-
Logs
- Verifying logs
- Types of logs
- Tuning log settings
-
High-Availability (HA) Solutions
- Configuring master–worker replication
- Configuring master–master replication
- Cluster setup
