About this video

MySQL is the world’s most popular open source database. Since the release of MySQL 5.0 in 2003, it is MySQL 8 that comes with a major update.

This course goes over the basics of MySQL administration, through examples on MySQL 8. It also covers the differences between various MySQL versions. It starts off with the basics: Installing MySQL and Creating users. After that, we will get sysbench up and running. Sysbench, responsible for issuing queries against databases, is the de-facto benchmarking tool for MySQL. With that hands-on lab environment at hand, we will learn about various database administration topics like backups, replication, monitoring, point in time recovery, switchovers, user management and version upgrades.

Upon completing this course, you will be able to set up new MySQL databases and perform basic administration tasks using the latest version.

All the code and supporting files for this course are available on Github at https://github.com/PacktPublishing/-MySQL-8-for-Administrators

Style and Approach

A hands-on course which maintains a balance between the theoretical and practical aspects of the subject with a vagrant based environment, which is followed through by labs.

Publication date:
May 2018
5 hours 25 minutes

About the Author

  • Peter Boros

    Peter Boros has more than 10 years of MySQL administration experience. Peter has also taught Oracle University courses about MySQL across EMEA, later he was a Principal Architect at Percona, a company specializing in MySQL consulting. Apart from this, he has worked with a few of the world’s largest MySQL deployments, belonging to prestigious web properties. This course is a product of Peter’s immense work experience and his expertise on the subject.

    Browse publications by this author

Latest Reviews

(2 reviews total)
It was good. But the course sometimes used another tool not origin from MySQL.
Ha risolto parecchi dubbi sull'amministrazione di mysql

Recommended For You

Advanced MySQL 8

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL

By Eric Vanier and 2 more
The Complete Python Course [Video]

Go from beginner to expert in Python by building projects. The best investment for your Python journey!

By Company Eco Web Hosting Ltd and 1 more
Mastering Windows Server 2019 - Second Edition

Enhance and secure your datacenter with the newest Microsoft server platform

By Jordan Krause
Learn Database Design with MySQL [Video]

A Complete Course to Master Database Design using MySQL

By Eduonix Learning Solutions