Detailed Course Outline
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
- Multi-Master Replication and Conflict Resolution
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
- Application Design 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
- Comparing MySQL Cluster with Other High-Availability Solutions
Conclusion
- Summary course contents and objectives
- Recap of MySQL Products, services, websites, training, documentation