SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

LINUX Training


The course was very helpful for my career. It opened up my eyes on how the web has evolved. I would recommend this course to my colleagues.
Comment from Canada Revenue Agency

1. Title

  • Professional MySQL Administration: Mastering Replication, Clustering and High Availability (MYSQLCL, 4 days)
    View PDF

2. Course Pre-requisites

  • Good knowledge of MySQL Database Administration

3. Target Audience

  • Professional database administrators who want to learn how to implement a MySQL Cluster

4. Dates and Pricing


May 29 to Jun 1, 2017$3,350.00/person
Oct 3 to Oct 6, 2017$3,350.00/person

5. Outline

Module 1: MYSQL High Availability Overview

Topic 1: The Need for High Availability

Topic 2: Overview of MySQL Enterprise Features

Topic 3: MySQL Replication

Topic 4: MySQL Cluster

Topic 5: MySQL High Availability Components

Module 2: MySQL Replication

Topic 1: Managing the MySQL Binary Log

Topic 2: MySQL Replication Threads and Files

Topic 3: MySQL Replication Environment Setup

Topic 4: Designing Replication Topologies

Topic 5: Multi-Master and Circular Replication

Topic 6: Performing a Controlled Switchover

Topic 7: Monitoring and Troubleshooting MySQL Replication

Topic 8: Replication with Global Transaction Identifiers (GTIDs)

Module 3: Installing MySQL Cluster

Topic 1: Hardware, Software, and Network Requirements

Topic 2: Choosing and Installing Cluster Distributions

Topic 3: Installing and Configuring Cluster Nodes

Topic 4: MySQL Cluster Auto-Installer

Topic 5: Starting a Cluster with a Basic Configuration

Topic 6: Upgrading a Cluster

Module 4: MySQL Cluster Architecture

Topic 1: The NDB storage engine

Topic 2: Clustered tables

Topic 3: SQL and NoSQL API nodes

Topic 4: Data Nodes and Node Groups

Topic 5: Partitions and Replicas

Topic 6: Checkpoints and the Redo Log

Topic 7: Redundancy and Resilience

Module 5: Designing a MySQL Cluster

Topic 1: Design Guidelines

Topic 2: Sizing Memory Usage

Topic 3: In-Memory and Disk Data Storage

Topic 4: Configuring Disk Data Storage

Topic 5: Designing Clusters for Scale and High Availability

Topic 6: Cluster Configuration Examples

Module 6: Configuring MySQL Cluster

Topic 1: MySQL Cluster Configuration Files

Topic 2: Basic Configuration Options: NodeId and HostName

Topic 3: Management Node Configuration

Topic 4: Data Node Configuration

Topic 5: Configuring Multi-Threaded Data Nodes

Topic 6: Cluster Program Startup Options

Topic 7: Viewing Cluster Configuration Information

Module 7: Maintaining a MySQL Cluster

Topic 1: Modifying Table Structure

Topic 2: Working with Command-Line Tools

Topic 3: About the Single-User Mode

Topic 4: Backing Up a Cluster

Topic 5: Restoring a Cluster from Backup

Module 8: MySQL Cluster Manager

Topic 1: Installing MySQL Cluster Manager Agent and Clients

Topic 2: Sites, Clusters, Hosts, Processes, Packages, and Configuration Attributes

Topic 3: Creating Managed Clusters

Topic 4: Importing a Configuration from an Unmanaged Cluster

Topic 5: Accessing Cluster Information

Topic 6: Site and Cluster Maintenance

Module 9: Monitoring MySQL Cluster

Topic 1: Monitoring Overview

Topic 2: Working with the ndb_mgm Client

Topic 3: Using the Cluster Log

Topic 4: ndbinfo Database

Topic 5: Status Variables

Topic 6: MySQL Enterprise Monitor

Module 10: Troubleshooting MySQL Cluster

Topic 1: Troubleshooting Methodology

Topic 2: About Heartbeats

Topic 3: Dealing with Configuration Issues

Topic 4: Dealing with Disk Activity Issues

Topic 5: Dealing with Application Design Issues

Module 11: Optimizing Performance

Topic 1: Performance Concepts

Topic 2: Identifying Queries for Optimization

Topic 3: Optimizing with Indexes

Topic 4: Using EXPLAIN

Topic 5: Adaptive Query Localization

Topic 6: Distribution Awareness

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette