MySQL Certification, MySQL Certified Associate

Course Outline

MySQL Cluster (SQL-4302) course overview

In the MySQL Cluster course, you will learn 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.

Who is MySQL Cluster (SQL-4302) training for?

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

Prerequisites for MySQL Cluster (SQL-4302) course

Required Prerequisites:

Basic knowledge of database concepts and SQL

Have previously worked with a MySQL Server instance and database

Be able to install MySQL

Have working knowledge of MySQL architecture

MySQL for Database Administrators (SQL-4502)

Suggested Prerequisites:

Can use MySQL tools to connect to the MySQL Server

Can state general knowledge of hardware and OS

What will I get?

Delegates will learn:

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

MySQL Cluster (SQL-4302) Course Contents

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

Introduction to MySQL Cluster Architecture

MySQL General Architecture

What is a Cluster?

Partitioning

Replication

Node Types

Fragments

Node Groups

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

Configure MySQL Cluster

MySQL Cluster Configuration

Management Node Configuration

Data Node Configuration

SQL Node Configuration

NDB Storage Engine

NDBs Storage Engine

NDBs Storage Method

NDBs Indexing

NDBs Communication Interconnects

NDBs Transaction Capabilities

Designing a Cluster

System Considerations

Cluster Setups

Handling Data in MySQL Cluster

Cluster Disk Data

Importing Data into Cluster Tables

Dropping Cluster Tables

MySQL Cluster Management

Clusters Management Console

Backing Up Cluster Data

Restoring Backups

Troubleshooting Backups

Modifying Table Definitions

MySQL Cluster Security

Cluster Security Best Practices

Secure Architectures

MySQL Cluster Performance

Performance Terms

Query Execution

Data Size/Usage Issues

Query Design

Configuration Options

Resolving MySQL Cluster Problems

Diagnostic Best Practices

Connection Issues

Arbitrator Shutdown

Resource Problems

Where to get additional help

MySQL Cluster Replication

Cluster Replication

Replication Preparation

Single Replication Channel

Redundant Replication Channels

Using MySQL Cluster Replication for Backups

Conclusion

Course Overview

Training and Certification Website

Course Evaluation

Thank You!

QA Session

View Complete Course outline

10:00	11:30	11:45	13:00	14:00	15:30	15:45
Classroom Activity This course explains how to create web pages from scratch using different techniques, such as	Tea Break	Classroom Activity This course explains how to create web pages from scratch using different techniques, such as	Lunch Break	Classroom Activity This course explains how to create web pages from scratch using different techniques, such as	Tea Break	Classroom Activity This course explains how to create web pages from scratch using different techniques, such as

Reviews

"Very good, clear, useful and to the point. Impressed!"

Anish Marnoor

NHS

"Great! I now have an understanding of the possibilities of the web."

Andrew Smith

HMV

"Very informative and at a very good pace. Learnt a lot quickly."

Victoria Virgo

TESCO

"Excellent, well structured and very useful."

Kimberly Cavanagh

SKANSKA

Looking for a 2-12 months training?

Database Administrator career programme

Upcoming dates

Delivery Formats

Remotely

join live classroom from anywhere

One-to-one

based on your requirements

In-house

at your office for your team

Course Outline

MySQL Cluster (SQL-4302) course overview

Who is MySQL Cluster (SQL-4302) training for?

Prerequisites for MySQL Cluster (SQL-4302) course

Required Prerequisites:

Suggested Prerequisites:

What will I get?

MySQL Cluster (SQL-4302) Course Contents

Introduction

Introduction to MySQL Cluster Architecture

Install and Start MySQL Cluster

Configure MySQL Cluster

NDB Storage Engine

Designing a Cluster

Handling Data in MySQL Cluster

MySQL Cluster Management

MySQL Cluster Security

MySQL Cluster Performance

Resolving MySQL Cluster Problems

MySQL Cluster Replication

Conclusion

Daily schedule

Classroom Activity

Classroom Activity

Classroom Activity

Classroom Activity

Looking for a 2-12 months training?

Database Administrator career programme

Our Trainers

Emiliano

Ross

Olu

Latest Reviews

Frequently Asked Questions

Looking for a
2-12 months
training?