O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

MySQL 8 for Administrators

Video Description

A beginner’s guide to the upgraded version of MySQL 8 Administration

About This Video

  • Setting up MySQL 8 and running with replication, learn about database administration topics like backups, replication, monitoring, point in time recovery, switchovers, user management and version upgrades.
  • Hands on experience of operations carried out on MySQL instances, running sysbench against them, and producing a workload.

In Detail

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