EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

MySQL Cluster

Course outline

4 days
Discuss this programme →

Duration

4 days

WHAT YOU WILL LEARN

  • Install and configure MySQL Cluster nodes.
  • Design simple and advanced cluster topologies.
  • Secure cluster nodes and data.
  • Backup and restore cluster data.
  • Troubleshoot common cluster problems.
  • Monitor and optimize cluster performance.
  • Use enterprise tools to manage large cluster deployments.

AUDIENCE

  • Web Administrator
  • Support Engineer
  • Application Developers
  • Database Administrators
  • System Administrator
  • Database Designers
  • Technical Consultant
  • Technical Administrator

PREREQUISITES

  • Must have a working knowledge of database concepts
  • Must have a working knowledge of UNIX/Linux command-prompt usage
  • Must have a basic knowledge of computer networking

METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentation, discussion and practical exercise.

COURSE OBJECTIVES

  • Identify and correct common cluster problems
  • Describe common cluster use cases
  • Configure replication between MySQL Clusters
  • Describe MySQL Cluster operation in virtualized and Cloud environments
  • Explain the concepts associated with MySQL Cluster
  • Describe the MySQL Cluster architecture
  • List features of the NDB Storage engine
  • Describe MySQL Cluster design considerations
  • Install MySQL Cluster
  • Configure a basic MySQL Cluster
  • Perform backup and recovery operations
  • Secure a MySQL Cluster
  • Maintain a MySQL Cluster by using the Management console and MySQL Cluster Manager
  • Monitor and improve performance on a MySQL Cluster

Module 1 - Introduction to MySQL Cluster

  • MySQL Overview, Products, Services
  • Websites and Other Documentation
  • Key Benefits and Use Cases
  • Node types

Module 2 - Installing MySQL Cluster

  • Hardware, Software, and Network Requirements
  • Choosing and Installing Cluster Distributions
  • Installing and Configuring Cluster Nodes
  • MySQL Cluster Auto-Installer
  • Starting a Cluster with a Basic Configuration
  • Upgrading a Cluster

Module 3 - MySQL Cluster Architecture

  • The NDB storage engine
  • Clustered tables
  • SQL and NoSQL API nodes
  • Data Nodes and Node Groups
  • Partitions and Replicas
  • Checkpoints and the Redo Log
  • Redundancy and Resilience

Module 4 - Configuring MySQL Cluster

  • MySQL Cluster Configuration Files
  • Basic Configuration Options: NodeId and HostName
  • Management Node Configuration
  • Data Node Configuration
  • Configuring Multi-Threaded Data Nodes
  • Cluster Program Startup Options
  • Viewing Cluster Configuration Information

Module 5 - Designing a MySQL Cluster

  • Design Guidelines
  • Sizing Memory Usage
  • In-Memory and Disk Data Storage
  • Configuring Disk Data Storage
  • Designing Clusters for Scale and High Availability
  • Cluster Configuration Examples

Module 6 - Maintaining a MySQL Cluster

  • Modifying Table Structure
  • Accessing the Cluster with Command-Line Tools
  • Single-User Mode
  • Backing Up a Cluster
  • Restoring a Cluster from Backup

Module 7 - Securing MySQL Cluster

  • Securing MySQL Cluster
  • Configuring Connection Security
  • Configuring Firewall Rules
  • Data Security
  • MySQL Server Node Security

Module 8 - MySQL Cluster Manager

  • Installing MySQL Cluster Manager Agent and Clients
  • Sites, Clusters, Hosts, Processes, Packages, and Configuration Attributes
  • Creating Managed Clusters
  • Importing a Configuration from an Unmanaged Cluster
  • Viewing Information About Your Sites and Clusters
  • Maintaining Your Sites and Clusters

Module 9 - Replicating Between MySQL Clusters

  • Replication in MySQL Cluster
  • Transaction Ordering and Epochs
  • Configuring Replication
  • Starting, Stopping, and Resetting Replication
  • Backups Using Replication Tables
  • Replication Resilience
  • Replication Information Repositories
  • Multi-Master Replication and Conflict Resolution

Module 10 - Monitoring MySQL Cluster

  • Introduction to Monitoring
  • Monitoring with the ndb_mgm Client
  • Using the Cluster Log
  • ndbinfo Database
  • Status Variables
  • MySQL Enterprise Monitor

Module 11 - Troubleshooting MySQL Cluster Problems

  • Starting to Troubleshoot
  • Heartbeats
  • Configuration Problems
  • Disk Activity Problems
  • Application Design Problems

Module 12 - Optimizing MySQL Cluster Performance

  • Performance Concepts
  • Identifying Queries for Optimization
  • Optimizing with Indexes
  • Using EXPLAIN
  • Adaptive Query Localization
  • Distribution Awareness
  • The Process of Optimizing and Benchmarking

Module 13 - MySQL Cluster Environments

  • MySQL Cluster and Virtualization
  • Node Deployment in Cloud Environments
  • Connecting to a Cluster with SQL and NoSQL APIs
  • Comparing MySQL Cluster with Other High-Availability Solutions

Module 14 - Conclusion

  • Summary course contents and objectives
  • Recap of MySQL Products, services, websites, training, documentation

Programme scope, delivery arrangements and suitability are confirmed during enquiry.