by Peter Boros | Released May 2018 | ISBN: 9781788398329

A beginner's guide to the upgraded version of MySQL 8 AdministrationAbout This VideoSetting 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 DetailMySQL 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 Show and hide more

1. Chapter 1 : Setting Up MySQL 8
   • Course Overview 00:03:49
   • A Lab About the Labs 00:10:24
   • MySQL 8 Installation from Rpm Packages 00:05:16
   • MySQL 8 Installation from Deb Packages 00:05:58
   • Set Up MySQL 8 from Binary Tarball 00:09:14
2. Chapter 2 : Configuring MySQL 8
   • Changing Configuration Parameters in my.cnf 00:07:11
   • Changing MySQL Configuration Parameters Online 00:10:04
   • New in MySQL 8: Persisting Configuration Parameters 00:10:08
   • Essential MySQL Configuration Parameters 00:06:17
   • Essential InnoDB 00:09:08
3. Chapter 3 : MySQL Users and Privilege System
   • Creating Databases and Users for Applications 00:09:43
   • Detour: MySQL Usage Basics 00:10:49
   • New in MySQL 8: Roles 00:07:28
   • Using sysbench 00:11:37
   • Authentication Changes 00:08:25
4. Chapter 4 : MySQL Replication
   • The Binary Log 00:12:25
   • Setting Up a Replication Slave 00:14:27
   • Introduction to GTID Replication 00:15:10
   • Migrating to GTID Replication 00:16:59
5. Chapter 5 : Monitoring
   • Command Line Monitoring 00:19:47
   • External Monitoring Systems 00:15:40
6. Chapter 6 : Backing Up MySQL
   • Logical Backups 00:09:00
   • Physical Backups 00:11:25
   • Point in Time Recovery 00:09:25
7. Chapter 7 : Advanced Replication and Switchovers
   • Switchovers 00:14:46
   • Advanced Replication 00:11:36
   • Checking Replication Consistency 00:15:53
8. Chapter 8 : Migration from 5.7
   • Migration Consideration 00:03:21
   • Replication Consistency Before Migration 00:11:15
   • Verifying Query Behavior Before Migration 00:18:42
Show and hide more