MySQL Cluster Training 1

General Course Description

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

What You Will Learn

This course is part one of two of the MySQL Cluster training course.

Course Objective

This course will help attendees learn the tasks a MySQL Cluster DBA goes thru when installing and managing a MySQL CLuster.

Version Covered

This course will cover MySQL Cluster 7.3 and SOME parts of MySQL Cluster 7.5, subject to instructors discretion.

Related Training

If possible, please attend MySQL DBA Training courses 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 Cluster Overview

  • MySQL Cluster Architecture Overview
  • Versions of MySQL Cluster
  • Common installation practices
  • MySQL Cluster Engines
  • Differences Between MySQL & MySQL Cluster


    • Module 2 - MySQL Cluster Architecture

  • MySQL Cluster Architecture Overview
  • NDB Storage Engine Overview
  • What to remember when moving to MySCL Cluster
  • MySQL Cluster Components
  • Important MySQL Cluster configuration components and file locations


    • Module 3 - MySQL Cluster Basics

  • Designing a MySQL Cluster
  • Hardware and OS Guidelines
  • Memory vs. Hard Disk space - Which is KING?
  • Whats New in MySQL CLuster
  • Command & File Layout Matrix


    • Module 4 - MySQL Cluster Hardware Considerations

  • Hardware specific bottlenecks
  • OS specific bottlenecks
  • Default MySQL cluster bottlenecks
  • Network specific bottlenecks
  • Hardware Matrix of Proven Servers


    • Module 5 - MySQL Cluster Installation

  • Installing MySQL Cluster
  • MySQL Cluster File Layout
  • MySQL Cluster Configuration Essentials
  • MySQL Cluster Common Configurations
  • MySQL Cluster Cheat Sheet


    • Module 6 - MySQL Cluster Manager

  • MySQL Cluster Manager Overview
  • Installing MySQL Cluster Manager
  • MySQL Cluster Manager Dashboard
  • MySQL Cluster views via Cluster Manager
  • MySQL Cluster Manager In Action


    • Module 7 - MySQL Cluster Settings To Know

  • NodeId and HostName
  • Command Line vs. Console
  • Memory Guidelines Minimums
  • Hard Disk Guidelines and Minimums
  • Components, settings and configuration files


    • Module 8 - Basic MySQL Cluster Troubleshooting

  • MySQL Cluster Troubleshooting Essentials
  • MySQL Cluster Logs to Monitor
  • MySQL Cluster Heartbeats
  • MySQL Cluster Processes
  • MySQL Cluster Debugging 101


    • Module 9 - MySQL Cluster 7.5 New Features and Benefits

  • MySQL Cluster Current and Previous Versions
  • MySQL Cluster 7.5 Features & Benefits
  • MySQL Cluster 7.5 Changes
  • MySQL Cluster Known Issues
  • MySQL Cluster 7.5 Upgrade Process


    • Course Logistics
    Course Schedule