Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
4 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
Request more information
Inquiry for: Myself My Company
By providing your contact details, you agree to our Privacy Policy
Thank You
Our learning consultant will get back to you in 1 business day
MySQL Cluster
WHAT YOU WILL LEARN
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.
AUDIENCE
Experienced Database Users
who want an in-depth understanding of MySQL Cluster.
PREREQUISITES
Requires Prerequisites
- Have previously worked with a MySQL Server instance and database
- Have working knowledge of MySQL architecture
- Be able to install MySQL
- Can state general knowledge of hardware and OS
- Can use MySQL tools to connect to the MySQL Server
- Basic knowledge of database concepts and SQL
METHODOLOGY
This program will be
conducted with interactive lectures, PowerPoint presentation, discussion and
practical exercise.
COURSE OBJECTIVES
Upon completion of this program, participants
should be able 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
Modules
- MySQL Overview, Products, Services and Enterprise Services
- Supported Operating Services
- MySQL Certification Program
- Training Curriculum Paths
- MySQL Website
- Installing MySQL
- Installing the world Database
- MySQL General Architecture
- What is a Cluster?
- Partitioning
- Replication
- Node Types
- Fragments
- Node Groups
- 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
- MySQL Cluster Configuration
- Management Node Configuration
- Data Node Configuration
- SQL Node Configuration
- NDBs Storage Engine
- NDBs Storage Method
- NDBs Indexing
- NDBs Communication Interconnects
- NDBs Transaction Capabilities
- System Considerations
- Cluster Setups
- Cluster Disk Data
- Importing Data into Cluster Tables
- Dropping Cluster Tables
- Clusters Management Console
- Backing Up Cluster Data
- Restoring Backups
- Troubleshooting Backups
- Modifying Table Definitions
- Cluster Security Best Terms
- Secure Architectures
- Performance Terms
- Query Execution
- Data Size/Usage Issues
- Query Design
- Configuration Options
- Diagnostic Best Practices
- Connection Issues
- Arbitrator Shutdown
- Resource Problems
- Where to get additional help
- Cluster Replication
- Replication Preparation
- Single Replication Channels
- Redundant Replication Channels
- Using MySQL Cluster Replication for Backups
Course Reviews
0
0 Ratings