MySQL Cluster (D89249)

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster's open-source and enterprise components.
 
Learn To:
  • 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.
 
Benefits to You
After taking this course, you will be able to evaluate MySQL Cluster in your application, and design a secure cluster topology to provide scalability and high availability. You will have developed the knowledge and skills to monitor and optimize the performance of your existing clusters and troubleshoot any problems that arise. You'll also be able to replicate between clusters that are separated by function or geography.
 
Target Audience
  • Application Developers
  • Database Administrators
  • System Administrator
  • Database Designers
  • Support Engineer
  • Technical Consultant
  • Technical Administrator
  • Web Administrator
 
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
 
Prerequisites
Required
  • MySQL for Beginners Ed 3
  • Oracle Linux 5 & 6 System Administration
Suggested
  • Must have a basic knowledge of computer networking
  • Must have a working knowledge of UNIX/Linux command-prompt usage
  • Must have a working knowledge of database concepts
  • MySQL server configuration and usage
  • Familiarity with VirtualBox
  • Linux administration skills
Details anzeigen
 
Course Topics
 
Introduction to MySQL Cluster
  • Node types
  • MySQL Overview, Products, Services
  • Key Benefits and Use Cases
  • Websites and Other Documentation
 
Installing MySQL Cluster
  • Installing and Configuring Cluster Nodes
  • Hardware, Software, and Network Requirements
  • Choosing and Installing Cluster Distributions
  • Upgrading a Cluster
  • Starting a Cluster with a Basic Configuration
  • MySQL Cluster Auto-Installer
 
MySQL Cluster Architecture
  • Checkpoints and the Redo Log
  • Partitions and Replicas
  • Clustered tables
  • Redundancy and Resilience
  • Data Nodes and Node Groups
  • SQL and NoSQL API nodes
  • The NDB storage engine
 
Configuring MySQL Cluster
  • Basic Configuration Options: NodeId and HostName
  • Viewing Cluster Configuration Information
  • Configuring Multi-Threaded Data Nodes
  • Data Node Configuration
  • Management Node Configuration
  • MySQL Cluster Configuration Files
  • Cluster Program Startup Options
 
Designing a MySQL Cluster
  • Cluster Configuration Examples
  • Configuring Disk Data Storage
  • Designing Clusters for Scale and High Availability
  • Sizing Memory Usage
  • In-Memory and Disk Data Storage
  • Design Guidelines
 
Maintaining a MySQL Cluster
  • Backing Up a Cluster
  • Modifying Table Structure
  • Single-User Mode
  • Restoring a Cluster from Backup
  • Accessing the Cluster with Command-Line Tools
 
Securing MySQL Cluster
  • Securing MySQL Cluster
  • MySQL Server Node Security
  • Data Security
  • Configuring Firewall Rules
  • Configuring Connection Security
 
MySQL Cluster Manager
  • Maintaining Your Sites and Clusters
  • Sites, Clusters, Hosts, Processes, Packages, and Configuration Attributes
  • Viewing Information About Your Sites and Clusters
  • Importing a Configuration from an Unmanaged Cluster
  • Installing MySQL Cluster Manager Agent and Clients
  • Creating Managed Clusters
 
Replicating Between MySQL Clusters
  • Replication Resilience
  • Replication Information Repositories
  • Transaction Ordering and Epochs
  • Starting, Stopping, and Resetting Replication
  • Multi-Master Replication and Conflict Resolution
  • Backups Using Replication Tables
  • Replication in MySQL Cluster
  • Configuring Replication
 
Monitoring MySQL Cluster
  • Introduction to Monitoring
  • Using the Cluster Log
  • ndbinfo Database
  • Status Variables
  • Monitoring with the ndb_mgm Client
  • MySQL Enterprise Monitor
 
Troubleshooting MySQL Cluster Problems
  • Configuration Problems
  • Application Design Problems
  • Starting to Troubleshoot
  • Heartbeats
  • Disk Activity Problems
 
Optimizing MySQL Cluster Performance
  • Distribution Awareness
  • Using EXPLAIN
  • Performance Concepts
  • Identifying Queries for Optimization
  • The Process of Optimizing and Benchmarking
  • Adaptive Query Localization
  • Optimizing with Indexes
 
MySQL Cluster Environments
  • Node Deployment in Cloud Environments
  • MySQL Cluster and Virtualization
  • Connecting to a Cluster with SQL and NoSQL APIs
  • Comparing MySQL Cluster with Other High-Availability Solutions
 
Conclusion
  • Recap of MySQL Products, services, websites, training, documentation
  • Summary course contents and objectives