MySQL Database Administration

Overview Learning objectives What you’ll learn Key facts Module listing FAQs What our customers say Get in touch

Course overview

This five-day MySQL Database Administration live virtual classroom course builds the practical DBA skills needed to manage MySQL 8 environments effectively. You’ll focus on configuring databases correctly, protecting data through user access controls and recovery planning, and improving performance in live environments. Mapped to the Oracle MySQL 8.0 DBA certification curriculum, the course helps you maintain stable, secure database services that respond effectively when availability or performance issues affect the business.

DBA capability for MySQL professionals

Ideal for database administrators, developers and technical professionals who need to manage MySQL environments with greater confidence, this course builds the capability needed to set up MySQL environments correctly, protect data and access, and keep database services reliable as demand changes. Through guided administration tasks, you’ll also practice the decisions DBAs make day to day, from configuring secure access to planning recovery and keeping services responsive under changing workloads.

Learning objectives

Explain MySQL server architecture
Use core administration tools
Compare storage engine options
Manage accounts, roles and privileges
Plan backup and restore activity
Schedule routine database tasks
Build replication configurations
Investigate performance constraints

What you’ll learn

This course focuses on the MySQL administration skills that make the biggest difference when database services need to stay protected, available and responsive. You’ll work through recovery planning, access control, replication and performance scenarios that reflect the decisions DBAs make in live environments. The aim is to help you move from routine administration to more confident, evidence-led decision-making when systems are under pressure.

Protect data when recovery matters

Learn how to approach backup and recovery with more confidence, from choosing suitable backup methods to restoring data and using binary logs during recovery. You’ll practice how to check that backups are usable, reduce uncertainty after data loss and support faster service restoration when incidents occur to ensure that recovery becomes a tested process rather than a last-minute reaction.

Control access with greater precision

Learn how to create users, assign roles and set privileges, giving the right people the right level of access. You’ll also cover password controls and auditing, helping you keep MySQL environments protected without blocking day-to-day work. This gives you a clearer way to manage access, spot risk and support security requirements.

Keep MySQL services available

Explore replication and high availability practices that help MySQL environments keep running when demand changes or components fail. You’ll work with replication health, lag, failover considerations and topology management, giving you the confidence to identify disruption early, reduce avoidable downtime and support database services that need to remain dependable under pressure.

Improve performance with evidence

Learn how to investigate performance using logs, status information, locking behaviour and Performance Schema insight before making changes. You’ll build a more structured approach to finding bottlenecks, validating tuning decisions and keeping database services responsive as workloads grow, reducing guesswork when users report slow queries or inconsistent application performance.

What’s included

Instructor-led training over five-days
Live virtual classroom environment
Hands-on exercises and live labs
All relevant course materials

Key facts

Certification

This course supports preparation for the Oracle MySQL 8.0 DBA 1Z0-908 exam, although the exam is not included.

Who it’s for

This course is suitable for DBAs, system administrators, developers and technical professionals managing MySQL environments.

Prerequisites

You should be familiar with SQL and basic MySQL. Some Linux or UNIX experience will help you get more from the course.

Exam information

The Oracle MySQL 8.0 DBA 1Z0-908 exam is not included with this course.

Optional extras

This course includes hands-on labs and access to learning materials for continued practice.

Pre-course

No preparation work is required for this course.

Full module listing

Click on each day below to see the breakdown of the modules that you'll cover on the course.

Day one

Day two

Day three

Day four

Day five

Day one

Session 1: THE SERVER, CLIENTS AND TOOLS

Introduction to MySQL
MySQL database server releases
MySQL database versions
The MySQL server
MySQL client connections
MySQL client programs
MySQL client libraries
The mysql command line tool
The mysqladmin program

Session 2: MYSQL WORKBENCH

Installation of MySQL Workbench
Connecting to MySQL Workbench
MySQL Workbench screens

Session 3: OBTAIN METADATA

What is metadata?
The mysqlshow client program
The SHOW and DESCRIBE commands
Obtaining data from the INFORMATION_SCHEMA
MySQL 8 transactional data dictionary
Generate statements using the INFORMATION_SCHEMA

Session 4: CONFIGURE THE SERVER

Start and stop the MySQL server
Status files
An overview of MySQL storage engines
MySQL Server options and variables
MySQL status variables
Configure MySQL auditing

Session 5: SQL MODES, LOG FILES AND BINARY LOGGING

SQL modes
The general Log
The error Log
The slow query log
The binary logs

Day two

Session 6: MYSQL ARCHITECTURE

Communication protocols used to connect a client to the server
The SQL parser and storage engine tiers
Installing and uninstalling plugins
How MySQL uses disk space
How MYSQL uses memory

Session 7: THE INNODB STORAGE ENGINE

Features of the Innodb engine
The system tablespace
Transactions and referential integrity
Physical characteristics of Innodb Tables
System tablespace configuration
File per table tablespace
File and row formats
Log file and buffer configuration
Redo logging optimization and flushing
Undo tablespaces and rollback segments
General tablespaces
Buffer and log file configuration
Temporary table tablespaces
Innodb status report
InnoDB shutdown options

Session 8: OTHER STORAGE ENGINES

Check engine usage
The MYISAM engine
The Merge engine
Other Engines: Archive, Memory, Blackhole, CSV, Spider, MyRocks
Mixing storage engines

Session 9: TABLE MAINTENANCE

Table maintenance operations
Check table
Repair table
Analyze table
Optimize table
MySQL check
Repair InnoDB tables
MyISAM table maintenance and repair utilities

Day three

Session 10: BACKUP AND RECOVERY

The advantages and disadvantages of different backup methods
Backup tool overview
What should be backed up?
Binary backups of MYISAM tables
Binary backups of Innodb tables
Performing hot backups with Percona XtraBackup
Create, prepare and restore from a Percona XtraBackup
Performing recovery using the binary logs
Import and export operations
Export and import using SQL
Export from the command line using mysqldump
Import from the command line using mysqlimport

Session 11: USER MANAGEMENT

User accounts
Creating users
Renaming users
Change a user password
Drop a user
Granting and revoking privileges
The USER table
Connection validation
Password validation plugins

Session 12: PRIVILEGES

Types of pivileges
Granting and revoking privileges
Setting resource limits
Resource management
Role management
The MySQL database
The SHOW GRANTS Command

Day four

Session 13: TRANSACTIONS AND LOCKING

Locking concepts
Levels of locking
Implicit table locking with MyISAM and InnoDB
Explicit table locking
Advisory locking
Monitoring Locks
Turning AUTOCOMMIT on and off
Using transaction locks
Possible causes of lock contention
Handling concurrency problems and deadlocks

Session 14: TUNING THE SERVER

Server configuration variables
Status configuration variables
Status variables
System variables
Per client variables
Performance schema overview

Session 15: THE EVENT SCHEDULER

Event scheduler concepts
Event scheduler configuration
Creating, altering and dropping events
Event scheduler monitoring
Events and privileges

Day five

Session 16: OVERVIEW OF HIGH AVAILABILITY

High availability goals
High availability concepts
Design for high availability
Definition of High availability
High availability terminology

Session 17: CONFIGURE MASTER SLAVE REPLICATION

Replication overview
When to use replication
Disadvantages of replication
Replication factors
Replication architecture
Complex replication topologies
Testing replication
Monitoring replication threads
Excluding databases or tables from replication
Example: Setting Up a Master Slave Replication
Replication Using GTIDs
Run replication from a remote host
Controlled switchover
Setup replication using encrypted connections

Session 18: ADMINISTER A REPLICATION TOPOLOGY

Replication Files and Threads
Configure a lagging slave
Monitoring replication
Troubleshooting issues with replication
Semi-synchronous versus asynchronous replication
Configure MySQL failover
Add a recovered MySQL server back into the topology

Session 19: MYSQL SERVER INSTALLATION, UPGRADE DEPLOYMENT SECURITY

MySQL distributions
Installing MySQL on Linux and UNIX operating systems
The installation directories
Set a password for the mysql root user
Upgrade the MySQL server
Deployment Security

FAQs

This five-day MySQL Database Administration course develops the skills needed to manage MySQL 8 environments with greater confidence. It covers practical DBA responsibilities including server configuration, access control, backup and recovery, replication, high availability and performance analysis, with hands-on exercises linked to real administration scenarios.

Who is this MySQL Database Administration course for?

This course is for DBAs, system administrators, developers and technical professionals who manage or support MySQL environments. It is also relevant for people moving towards a DBA-focused role, particularly where they need stronger skills in configuration, security, recovery, replication and performance management.

What practical skills will I develop?

You will practice the administration tasks that keep MySQL environments running effectively. These include configuring the server, working with MySQL Workbench and command-line tools, managing users and privileges, planning backup and recovery activity, using logs and metadata, handling transactions and locks, configuring replication and investigating performance issues.

Does the course cover backup and recovery?

Yes. The course covers logical and physical backup approaches, including export and import activity, mysqldump, mysqlimport and Percona XtraBackup. You will also look at binary logs and recovery processes, helping you understand how to restore data and reduce uncertainty when a database incident affects service.

Will I learn how to manage users and privileges?

Yes. You will learn how to create and manage user accounts, work with roles, grant and revoke privileges, apply password validation and use connection controls. This helps you give users the access they need while reducing unnecessary permissions and supporting more consistent database security.

How does the course support performance management?

The course covers server tuning, status variables, system variables, per-client variables and the Performance Schema. You will learn how to interpret performance information before making changes, helping you investigate slow queries, locking issues and workload pressure with a more structured approach.

Does the course include replication and high availability?

Yes. You will cover replication concepts, traditional master-slave replication, GTID-based replication, encrypted connections, lag monitoring, troubleshooting and failover considerations. These areas help you understand how MySQL environments can be configured to support availability, scalability and recovery when workloads change or individual components fail.

Is there an exam included with this course?

The exam is not included. The course supports preparation for the Oracle MySQL 8.0 DBA 1Z0-908 exam by covering relevant administration areas, including configuration, user management, backup and recovery, replication, high availability and performance tuning.

What our customers say

‘The lecturer was amazing - so passionate and knowledgeable, which made the sessions really enjoyable and easy to follow. I learned a lot and felt supported throughout. I would definitely consider returning for future sessions and highly recommend TSG training to my colleagues.’

Kamila, Data Administrator - Retail / Hire

‘The course was particularly good and certainly took my PL/SQL to another level. A lot of extremely useful stuff beyond programming. The instructor was particularly good and very knowledgeable and anything he didn't know he would investigate and come with the explanation. That is not my first class with him and one of the reasons I book with this company.’

Caroline, Government

Why study with TSG?

25+ years' experience

Trusted by individuals, businesses and public sector organisations for over 25 years.

20,000+ learners trained

Join a network of learners focused on developing their software testing skills

98% customer satisfaction

TSG trainers are frequently rated as ‘good’ or ‘excellent’ by our learners

Similar courses

MySQL

Course

Introduction to MySQL

From £1,255

MySQL

Course

MySQL for Developers

From £2,090

MySQL

Course

MySQL for Developers

From £2,090

MySQL

Course

Introduction to MySQL

From £1,255

Python

Course

Introduction to Python and Data Analysis

From £2,095