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.
MySQL Database Administration
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
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.
Course syllabus
Dive into the detail of the course by looking at the syllabus below.
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
Day one
- Session 2: MYSQL WORKBENCH
- Installation of MySQL Workbench
- Connecting to MySQL Workbench
- MySQL Workbench screens
Day one
- 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
Day one
- 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
Day one
- 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
Day two
- 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
Day two
- 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
Day two
- 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
Day three
- 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
Day three
- 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
Day four
- Session 14: TUNING THE SERVER
- Server configuration variables
- Status configuration variables
- Status variables
- System variables
- Per client variables
- Performance schema overview
Day four
- 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
Day five
- 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
Day five
- 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
Day five
- 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