MYSQL Cluster Ed2

Introduction to MySQL Cluster

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

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

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

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

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

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

Securing MySQL Cluster

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

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

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

Monitoring MySQL Cluster

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

Troubleshooting MySQL Cluster Problems

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

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

MySQL Cluster Environments

• MySQL Cluster and Virtualization
• Node Deployment in Cloud Environments
• Connecting to a Cluster with SQL and NoSQL APIs

Conclusion

• Summary course contents and objectives
• Recap of MySQL Products, services, websites, training, documentation
• Comparing MySQL Cluster with Other High-Availability Solutions
• Application Design Problems
• Multi-Master Replication and Conflict Resolution