MySQL Cluster

MySQL Cluster

1 INTRODUCTION

1.1 Learning Objectives
1.2 The MySQL Overview
1.2.1 MySQL Partners
1.3 MySQL Products
1.3.1 MySQL Database Products
1.3.2 MySQL GUI Tools
1.3.3 Other MySQL Tools
1.3.4 MySQL Drivers
1.3.5 Solutions for Embedding MySQL
1.4 MySQL Services.
1.4.1 MySQL Training
1.4.2 MySQL Certification
1.4.3 MySQL Consulting
1.4.4 MySQL Support
1.5 Community vs. Enterprise
1.6 Supported Operating Systems
1.7 MySQL Certification Program
1.8 Training Curriculum Paths
1.9 MySQL Website
1.9.1 MySQL Community Web Page
1.10 Installing MySQL

2 INTRODUCTION TO MYSQL CLUSTER

2.1 Overview
2.2 MySQL General Architecture
2.2.1 MySQL Server
2.2.2 Client Programs
2.2.3 Communication Protocols
2.2.4 MySQL Non-Client Utilities
2.2.5 SQL Parser and Storage Engine Tiers
2.2.6 Storage Engine Breakdown
2.2.7 NDB Storage Engine
2.3 What is a Cluster?
2.3.1 Shared-nothing vs. Shared-disk
2.3.2 MySQL Cluster Hardware
2.4 Partitioning
2.5 Replication.
2.6 Node Types. Fragments
2.8 Node Groups. Arbitration Heartbeats
2.8.3 Two-Phase Commit Summary

3 INSTALL AND START MYSQL CLUSTER

3.1 Overview
3.2 Initiate MySQL Cluster
3.3 Starting a Management Node
3.4 Starting the Data Nodes
3.4.1 Data Node Startup Options
3.5 Connecting the SQL Nodes
3.5.1 Creating A Clustered Table
3.6 Startup Phases.
3.7 Restart a Cluster
3.8 Testing High-Availability
3.9 Upgrading MySQL Cluster

4 CLUSTER CONFIGURATION FILE

4.1 Overview
4.2 MySQL Cluster Configuration
4.3 Management Node Configuration
4.4 Data Node Configuration
4.5 SQL Node Configuration

5 NDB STORAGE ENGINE

5.1 Overview
5.2 The NDB Storage Engine
5.3 NDB's Storage Method
5.3.1 In-Memory Storage
5.3.2 Disk Based Storage
5.4 NDB Indexing
5.4.1 HASH Index
5.4.2 Ordered Index
5.4.3 Storage of Indexes
5.5 NDB's Communication Interconnects
5.6 NDB's Transactional Capabilities
5.6.1 Durability

6 DESIGNING A CLUSTER

6.1 Overview
6.2 System Considerations
6.2.1 CPU Considerations
6.2.2 Network Connections
6.2.3 Disk-Based Storage
6.2.4 Memory - RAM
6.2.5 Putting it All Together
6.3 Cluster Setups
6.3.1 Load Balancing and Failover
6.3.2 Physical Cluster Setups
6.3.3 Network Redundancy

7 HANLDING DATA IN MYSQL CLUSTER

7.1 Overview
7.2 Cluster Disk Data
7.2.1 Creating the Tablespace
7.2.2 Create a Disk Data Table
7.2.3 Create a disk data column.
7.2.4 Monitoring Free Space
7.3 Importing Data into Cluster Tables
7.3.1 Converting an Existing Table to MySQL Cluster
7.3.2 Importing Table Typical Errors
7.4 Dropping Cluster Tables

8 MYSQL CLUSTER MANAGEMENT

8.1 Overview
8.2 MySQL Cluster's Management Console.
8.2.1 Cluster Status
8.2.2 Cluster Control Commands
8.2.3 Cluster Logging Commands
8.2.4 Single User Commands
8.2.5 Cluster Backup Commands
8.3 Backing Up Cluster Data
8.3.1 MySQL Cluster's Native Backup Tool
8.3.2 Backup Data.
8.3.3 mysqldump
8.4 Restoring Backups
8.4.1 Recovering MySQL Cluster's Native Backup Files
8.4.2 Restoring mysqldump Files
8.5 Troubleshooting Backups
8.6 Modifying Table Definitions

9 MYSQL CLUSTER SECURITY .

9.1 Overview
9.2 Cluster Security Best Practices
9.3 Secure Architectures

10 MYSQL CLUSTER PERFORMANCE

10.1 Overview
10.2 Performance Terms
10.2.1 Performance Terms
10.2.2 Benchmarking
10.3 Query Execution
10.3.1 Indexes
10.3.2 Data Retrieval
10.3.3 EXPLAIN
10.3.4 Index Statistics
10.3.5 Query Cache
10.3.6 Horizontal Partitioning
10.4 Data Size/Usage Issues
10.5 Query Design

11 RESOLVING MYSQL CLUSTER PROBLEMS

11.1 Overview
11.2 Diagnostics Best Practices
11.2.1 Management Client Basics
11.2.2 Cluster Logs
11.3 Connection Issues
11.4 Arbitrator Shuts Down Node
11.5 Resource Problems
11.6 Where to Get Additional Help

12 MYSQL CLUSTER REPLICATION

12.1 Overview
12.2 Cluster Replication
12.2.1 Cluster Replication Logging (binlog)
12.2.2 MySQL Cluster Replication System Tables
12.2.3 Known Issues
12.3 Replication Preparation
12.4 Single Replication Channel
12.4.1 Batched Updates
12.5 Redundant Replication Channels
12.5.1 Implement Failover
12.6 Using MySQL Cluster Replication for Backups
12.6.1 Restoring a Cluster Replication Backup

13 CONCLUSION

13.1 Course Objectives
13.2 Training and Certification Website
13.3 Course Evaluation