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

LINUX Training


This is the best of many WebEx training sessions I ve taken part in.
Comment from HRSDC

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


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