MySQL Cluster (SQL-4302)

Požadované predpokladané znalosti

• 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)

Doporučené predpokladané znalosti

• Can use MySQL tools to connect to the MySQL Server
• Can state general knowledge of hardware and OS

Ciele kurzu

• 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

Témy kurzu

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!