MySQL Cluster Ed 2

Cost $4000

Course Code
D62018GC20

Duration
4 days

Format
Live Virtual Class

What you will learn

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.

Participate in Hands-on, Interactive Labs

In addition to benefiting from interactive instruction, you'll also get a chance to create and configure several different clusters through hands-on exercises. You'll start by creating simple clusters manually, or with the MySQL Cluster Auto Installer. You will then create multiple clusters that are separated by a firewall, as well as clusters that use replication. These hands-on exercises will help you troubleshoot common problems and examine and optimize the performance of the cluster.


Prerequisites

Suggested Prerequisite

  • MySQL for Beginners Ed 3
  • MySQL for Database Administrators Ed 3
  • Oracle Linux 5 & 6 System Administration Ed 2
  • Linux administration skills
  • MySQL server configuration and usage
  • Familiarity with VirtualBox

Required Prerequisite

  • Must have a working knowledge of database concepts
  • Must have a working knowledge of UNIX/Linux command-prompt usage
  • Must have a basic knowledge of computer networking

Audience

  • Administrator
  • Architect
  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

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

Topics

  • 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

 

  • 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

Enroll for MySQL Cluster Ed 2

MySQL Cluster Ed 2

$4,000.00

Short description

Clear
SKU: D62018GC20 Categories: ,

Additional information

Schedules

Dec 13 2021 – Dec 16 2021 (4 days) 9:00 AM – 5:00 PM US-Pacific, Jun 20 2022 – Jun 23 2022 (4 days) 9:00 AM – 5:00 PM US-Eastern

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0