Description

MySQL Cluster is a distributed, highly available, fault-tolerant database solution developed by Oracle. It offers a distributed database architecture designed to provide continuous availability, linear scalability and fault tolerance without compromising performance.

Who is this training for ?

For whom ?

Database administrators

Systems engineers

Developers

Software architects

Prerequisites

• Basic knowledge of databases
• MySQL basics
• Knowledge of operating systems
• Understanding networks
• Experience in system administration or software development

Training objectives

• Understand the advantages.
• Know how to implement the installation and configuration of a cluster.
• Performance optimization and administration of a cluster architecture.

Training program

• Module 1 : Introduction
  • Introduction to high availability and scalability needs
  • Introduction to MySQL NDB Cluster and its benefits
  • Understand the differences between MySQL Server and MySQL NDB Cluster
  • Introduction to MySQL Cluster Manager
• Module 2: MySQL Cluster Database
  • The architecture:
  • No-share architecture and its implications
  • NDB data nodes and SQL nodes
  • Distribution and partitioning of data
  • Management nodes and their role
  • Key features:
  • High availability with automatic failover
  • Horizontal scalability for increased throughput
  • Real-time data access with in-memory tables
  • ACID transactions and data consistency
  • Replication across multiple geographies
  • Security:
  • User authentication and authorization
  • Network security considerations
  • Data encryption options
  • Monitoring and optimization performance:
  • Key metrics to track
  • Performance optimization tools and techniques
  • Resource utilization analysis
• Module 3: MySQL Cluster Manager
  • Installation and configuration:
  • Setting up the management environment
  • Configuring nodes and clusters
  • Security considerations
  • Managing clusters:
  • Creating and removing clusters
  • Starting, stopping, and restarting clusters
  • Scaling online and adding/removing nodes
  • Backups and restores
  • Upgrades and deployments
  • Configuration changes and adjustments
  • Automation and scripting:
  • Automate common tasks using the API Manager
  • Scripting for complex deployments
  • Integrate with workflows DevOps work
• Module 4: Advanced Topics
  • Geo-replication for global deployments
  • Using MySQL Cluster with other applications
  • Troubleshooting and resolving issues
  • Best practices for deployment and management
  • Future Trends and Roadmap for MySQL NDB Cluster