MySQL

MySQL Cluster

Learn about MySQL from Instructors with Real World Expertise.

A 3 day intermediate course teaching students the important details of clustering that will help them get started with MySQL Cluster.

MySQL Training Overview:

In this MySQL Cluster training, students will learn the important details of clustering that will help you get started with MySQL Cluster. Expert Oracle University instructors will teach you how to properly configure and manage the cluster nodes to ensure high availability. By investing in this course, you’ll develop the skills to install the different nodes and better understand the internals of the cluster.

Course Objectives:

  • Explain the concepts of MySQL Cluster in detail
  • Describe the different nodes in MySQL Cluster and their purposes
  • Explain how the data is distributed and replicated in the MySQL Cluster
  • Install all the different nodes used in the MySQL Cluster
  • Start and stop the different nodes as needed
  • Understand how the different configuration files work and be able to configure all possible types of clusters
  • Put the cluster in single user mode, and understand when this is necessary
  • Know how to upgrade cluster components and configuration settings
  • Explain how node failure is detected and handled in the cluster
  • Describe how node restart works internally
  • Explain how system restart works and when this type of restart is needed
  • Take backups and restore the data from backups
  • Describe the internal parts of the data nodes
  • Explain how the different types of data scans are performed
  • Explain the difference between the different index types
  • Configure the cluster for optimal performance

Target Audience:

New or existing users of MySQL, who have little or no previous experience with MySQL cluster.

Prerequisites:

  • Can state general knowledge of hardware and OS
  • Can use MySQL tools to connect to the MySQL Server

Duration: 3 Days

Course Outline:

Introduction

Overview:

  • MySQL Overview, Products, Services and Enterprise Services
  • Supported Operating Services
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Website
  • Installing MySQL
  • Installing the world Database

Database Basics

Overview:
  • MySQL General Architecture
  • What is a Cluster?
  • Partitioning
  • Replication
  • Node Types
  • Fragments
  • Node Groups

Install and Start MySQL Cluster

Overview
  • Initiate MySQL Cluster
  • Start a Management Node
  • Starting the Data Nodes
  • Connecting the SQL Nodes
  • Startup Phases
  • Restart a Cluster
  • Testing High-Availability
  • Upgrading MySQL Cluster

Configure MySQL Cluster

Overview:

  • MySQL Cluster Configuration
  • Management Node Configuration
  • Data Node Configuration
  • SQL Node Configuration

NDB Storage Engine

Overview:
  • NDBs Storage Engine
  • NDBs Storage Method
  • NDBs Indexing
  • NDBs Communication Interconnects
  • NDBs Transaction Capabilities

Designing a Cluster

Overview

  • System Considerations
  • Cluster Setups

Handling Data in MySQL Cluster

Overview

  • Cluster Disk Data
  • Importing Data into Cluster Tables
  • Dropping Cluster Tables

MySQL Cluster Management

Overview

  • Clusters Management Console
  • Backing Up Cluster Data
  • Restoring Backups
  • Troubleshooting Backups
  • Modifying Table Definitions

MySQL Cluster Security

Overview

  • Cluster Security Best Practices
  • Secure Architectures

MySQL Cluster Performance

Overview

  • Performance Terms
  • Query Execution
  • Data Size/Usage Issues
  • Query Design
  • Configuration Options

Resolving MySQL Cluster Problems

Overview

  • Diagnostic Best Practices
  • Connection Issues
  • Arbitrator Shutdown
  • Resource Problems
  • Where to get additional help

MySQL Cluster Replication

Overview

  • Cluster Replication
  • Replication Preparation
  • Single Replication Channel
  • Redundant Replication Channels
  • Using MySQL Cluster Replication for Backups

Conclusion

Overview

  • Course Overview
  • Training and Certification Website
  • Course Evaluation
  • QA Session

Looking for something else? View all courses

Start Learning

Learn from Instructors with Real World Expertise.