EncartaLabs

MySQL Cluster

( Duration: 3 Days )

In MySQL Cluster training course, Participants will learn the important details of clustering that will help them get started with MySQL Cluster. They will also learn on how to properly configure and manage the cluster nodes to ensure high availability.

By attending MySQL Cluster workshop, Participants will learn to:

  • 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

  • Have previously worked with a MySQL Server instance and database
  • Be able to install MySQL
  • Have working knowledge of MySQL architecture
  • Basic knowledge of database concepts and SQL

COURSE AGENDA

1

Introduction

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

Introduction to MySQL Cluster Architecture

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

Install and 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
4

Configure MySQL Cluster

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

NDB Storage Engine

  • NDBs Storage Engine
  • NDBs Storage Method
  • NDBs Indexing
  • NDBs Communication Interconnects
  • NDBs Transaction Capabilities
6

Designing a Cluster

  • System Considerations
  • Cluster Setups
7

Handling Data in MySQL Cluster

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

MySQL Cluster Management

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

MySQL Cluster Security

  • Cluster Security Best Practices
  • Secure Architectures
10

MySQL Cluster Performance

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

Resolving MySQL Cluster Problems

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

MySQL Cluster Replication

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top