MySQL DBA Training 1

General Course Description

This instructor led hands on training course focuses on the DBA training of MySQL and is an EXCELLENT overview of the MUST know commands and tasks NEEDED to be a successful MySQL DBA. 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 DBA Training 1

What You Will Learn

This course is part one of two of the DBA training course on MySQL.

Course Objective

This course will help attendees learn the tasks a DBA goes thru when installing and using 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 2 course 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 Architecture Overview

  • MySQL Architecture overview
  • Versions of MySQL
  • Common installation practices
  • File layout considerations
  • Platform specific considerations


    • Module 2 - MySQL Hardware Considerations

  • Hardware scalability using 1U, 2U or 4U
  • Memory usage and utilization guidelines
  • RAID, NFS and iSCSI considerations
  • Network considerations
  • Testing and validating current performance


    • Module 3 - MySQL OS and Engine Considerations

  • Selecting the correct OS for MySQL
  • OS performance considerations
  • 32 or 64 bit
  • Overview of built in MySQL Engines
  • MySQL Engine Benefits Matrix


    • Module 4 - MySQL Known Bottlenecks

  • Hardware specific bottlenecks
  • OS specific bottlenecks
  • MySQL default bottlenecks
  • Network specific bottlenecks
  • Basic performance improvement matrix


    • Module 5 - Performance Tuning for MySQL

  • Hardware based tuning options
  • OS based tuning options
  • MySQL specific my.cnf options
  • Scripts to simplify performance tuning
  • Learned Tuning Tips and Tricks


    • Module 6 - Stress Testing MySQL

  • Stress testing overview
  • Open Source tools of the trade
  • Creating baselines for before & after
  • Understanding MySQL vs web stress test
  • Monitoring performance changes


    • Module 7 - MySQL EXPLAIN Essentials

  • Introduction to EXPLAIN
  • EXPLAIN usage
  • Using EXPLAIN for tuning
  • Basic EXPLAIN column overview
  • Performance tuning with EXPLAIN


    • Module 8 - MySQL Query Optimization

  • Slow Query Overview & Usage
  • How queries are being processed
  • MySQL query specific variables
  • MySQL Query Optimizer Overview
  • Tips & tricks to optimize queries


    • Module 9 - MySQL Query Cache's & Types

  • MySQL Query Cache
  • Query Cache Memory usage and tuning
  • Cache Table Overview
  • Query Cache Fragmentation
  • Utilizing memcached


    • Course Logistics
    Course Schedule