MySQL Cluster (SQL-4302)

OCE Oracle Certified Expert, MySQL 5.1 Cluster Database Administrator - Exam number: 1Z0-875

This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Database Administrator
Career Programme

Looking for a 2-12 months training?

Choose

Database Administrator career programme

Upcoming dates

There are no open public schedule dates for MySQL Cluster (SQL-4302) course. We can offer you a private training or arrange a public course for you. Contact us here and we can make arrangements for your course.

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

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

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
Video Placeholder

Looking for a
2-12 months
training?

Choose

Database Administrator career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them