MySQL Upgrading Essentials Training

General Course Description

This instructor led hands on training course focuses on the various ways you can UPGRADE MySQL and will ensure that all new or soon to be MySQL DBA's will know what and how to do their job. Students will get over 15+ hours of hands-on-labs! The labs account for over 80% of the class and allows the student to learn FIRST hand from real world scenarios. Your instructor is a former Sun Microsystems employee & a MySQL Certified DBA & have a minimum of 10 years of MySQL deployment experience.

Course Details: MySQL Upgrading Essentials

What You Will Learn

This course will show you the various ways of upgrading MySQL on various OS's.

Course Objective

This course will help attendees learn the various ways to UPGRADE MySQL.

Version Covered

This course will cover MySQL 5.6 and SOME parts of 5.7, subject to instructors discretion.

Related Training

If possible, please attend MySQL DBA Training coursef as this will complete the FULL training.

Class Details

Who Should Attend
  • Sales Engineers
  • Systems Engineers
  • Database Administrators
  • IT Managers
  • Developers
    • Prerequisites
  • Basic understanding of databases - helpful but NOT necessary.
  • Understanding of installing and uninstalling programs.
  • Basic knowledge of the Internet, networks and ports.
  • Have read and know a little about MySQL.
  • Basic grasp of command line execution syntax and editors.
    • Course Outline

    Module 1 - MySQL Upgrading Essentials

  • MySQL 5.5 Overview and Benefits
  • MySQL 5.6 Overview and Benefits
  • MySQL 5.7 Overview and Benefits
  • Upgrading 101
  • Thinking Outside of MySQL when Upgrading


    • Module 2 - MySQL Upgrading Environments

  • Upgrading MySQL Master
  • Upgrading MySQL Master --> Slave
  • Upgrading MySQL Master <-> Master
  • MySQL Configuration Changes to Remember
  • MySQl Engine Changes to Remember


    • Module 3 - MySQL Configuration Changes to Remember

  • MySQL Configuration Changes
  • MySQL Parameter Changes
  • MySQL Hardware Changes
  • MySQL Upgrading Via Linux APT
  • MySQL Upgrading Via Linux Yum


    • Module 4 - Upgrading MySQL on Windows

  • How Is MySQL Windows Different
  • MySQL On Windows File Layout
  • MySQL On Windows Gotchas
  • MySQL On Windows MUST read documentation
  • MySQL On Windows Upgrade Tools


    • Module 5 - MySQL On Windows Upgrading Options

  • Five Rules of Upgrading NEVER to break
  • MySQL On Windows In Place Upgrade
  • MySQL On Windows SQL Dump
  • MySQL On Windows Upgraded Server
  • MySQL On Windows Testing The Upgrade


    • Module 6 - Upgrading MySQL on Linux

  • How Is MySQL Linux Different
  • MySQL On Linux File Layout
  • MySQL On Linux Gotchas
  • MySQL On Linux MUST read documentation
  • MySQL On Linux Upgrade Tools


    • Module 7 - MySQL On Linux Upgrading Options

  • Five Rules of Upgrading NEVER to break
  • MySQL On Linux In Place Upgrade
  • MySQL On Linux SQL Dump
  • MySQL On Linux Upgraded Server
  • MySQL On Linux Testing The Upgrade


    • Module 8 - Upgrading MySQL on Solaris

  • How Is MySQL Solaris Different
  • MySQL On Solaris File Layout
  • MySQL On Solaris Gotchas
  • MySQL On Solaris MUST read documentation
  • MySQL On Solaris Upgrade Tools


    • Module 9 - MySQL On Solaris Upgrading Options

  • Five Rules of Upgrading NEVER to break
  • MySQL On Solaris In Place Upgrade
  • MySQL On Solaris SQL Dump
  • MySQL On Solaris Upgraded Server
  • MySQL On Solaris Testing The Upgrade


    • Course Logistics
    Course Schedule