Course MySQL Cluster

Duration (days): 3
Price (CZK): 20000

MySQL Cluster topics:

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

• Secure Architectures

MySQL Cluster Performance

• Query Execution
• Data Size/Usage Issues
• Query Design
• Configuration Options

Resolving MySQL Cluster Problems

• Diagnostic Best Practices
• Connection Issues
• Arbitrator Shutdown
• Resource Problems

MySQL Cluster Replication

• Cluster Replication
• Single Replication Channel
• Redundant Replication Channels
• Using MySQL Cluster Replication for Backups

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs