MySQL Cluster (SQL-4302)

Duration 3 Days		  
 


About this Course

  • Do you wonder what MySQL Cluster is all about?
  • Do you want to ensure the high availability of your data?
  • Are you sure your MySQL Cluster is configured optimally?
  • Do you want to learn all the tips and tricks in running a highly available MySQL Cluster?

Then MySQL Cluster for High Availability is for you! An Authorized MySQL instructor will teach you the important details of clustering that you will need to understand to get started with MySQL Cluster, how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes and provide a better understanding of the internals of the cluster.

Audience Profile

  • Experienced database users who want an in-depth understanding of MySQL Cluster.

At Course Completion

After completing this course, you should be able to:

  • Describe the fundamentals of cluster technologies
  • 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

Prerequisites

Students, who wish to attend this course, should have attended the MySQL 5.0 for DBAs course or have similar knowledge, demonstrated through e.g. MySQL DBA certification:

  • Basic knowledge of database concepts and SQL
  • Be able to install MySQL
  • Have previously worked with a MySQL Server instance and database
  • Have working knowledge of MySQL architecture
  • Can use MySQL tools to connect to the MySQL Server
  • Can define table structures, index structures, constraints and other objects
  • Can state general knowledge of hardware and OS

Course Outline

Chapter 1: Introduction

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

Chapter 2: Introduction to MySQL Cluster Architecture

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

Chapter 3: Install & Start MySQL Cluster

  • 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

Chapter 4: Configure MySQL Cluster

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

Chapter 5: NDB Storage Engine

  • NDB's Storage Engine
  • NDB's Storage Method
  • NDB's Indexing
  • NDB's Communication Interconnects
  • NDB's Transaction Capabilities

Chapter 6: Designing a Cluster

  • System Considerations
  • Cluster Setups

Chapter 7: Handling Data in MySQL Cluster

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

Chapter 8: MySQL Cluster Management

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

Chapter 9: MySQL Cluster Security

  • Cluster Security Best Practices
  • Secure Architectures

Chapter 10: MySQL Cluster Performance

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

Chapter 11: Resolving MySQL Cluster Problems

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

Chapter 12: MySQL Cluster Replication

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

Chapter 13: Conclusion

  • Course Overview
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • Q&A Session