Oracle Training: Replication, Clustering & High Availability


Course Delivery

Live Instructor-Led Training

Course Description

The course Replication, Clustering & High Availability (Oracle Training) is an exploration of clustering & high availability with MySQL. The training includes clustering basic concepts and discusses the hardware, topology & software requirements of a clustered MySQL implementation. The course covers MySQL cluster design, installation, configuration & implementation. This MySQL course also includes a full discussion on MySQL cluster monitoring, troubleshooting & optimization.

Course Dates and Pricing


Oct 2 - 5, 2018$3,350.00Oct 30 - Nov 2, 2018$3,350.00Nov 27 - 30, 2018$3,350.00

Course Outline

MYSQL High Availability Overview

The Need for High Availability
Overview of MySQL Enterprise Features
MySQL Replication
MySQL Cluster
MySQL High Availability Components

MySQL Replication

Managing the MySQL Binary Log
MySQL Replication Threads and Files
MySQL Replication Environment Setup
Designing Replication Topologies
Multi-Master and Circular Replication
Performing a Controlled Switchover
Monitoring and Troubleshooting MySQL Replication
Replication with Global Transaction Identifiers (GTIDs)

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

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

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

Maintaining a MySQL Cluster

Modifying Table Structure
Working with Command-Line Tools
About the Single-User Mode
Backing Up a Cluster
Restoring a Cluster from Backup

MySQL Cluster Manager

Installing MySQL Cluster Manager Agent and Clients
Sites, Clusters, Hosts, Processes, Packages, and Configuration Attributes
Creating Managed Clusters
Importing a Configuration from an Unmanaged Cluster
Accessing Cluster Information
Site and Cluster Maintenance

Monitoring MySQL Cluster

Monitoring Overview
Working with the ndb_mgm Client
Using the Cluster Log
ndbinfo Database
Status Variables
MySQL Enterprise Monitor

Troubleshooting MySQL Cluster

Troubleshooting Methodology
About Heartbeats
Dealing with Configuration Issues
Dealing with Disk Activity Issues
Dealing with Application Design Issues

Optimizing Performance

Performance Concepts
Identifying Queries for Optimization
Optimizing with Indexes
Using EXPLAIN
Adaptive Query Localization
Distribution Awareness

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related LINUX Training

IT Security Training: Offensive & Defensive Hack Proofing

The course Offensive & Defensive Hack Proofing (IT Security Training) is an introduction to white hat hacking. The course teaches you how to perform every stage of the hacking process so that you may protect your environment. The training includes tools for information gathering & target scoping, target discover & enumeration, vulnerability mapping & social engineering. You are taught how to use the Metasploit Framework to perform target identification & exploitation so that you may stop it from happening to you. The progressive & hands-on practical lab allow you to execute a hack from initial identification to privilege escalation & maintenance. Stop hackers in their tracks today! Training course titled IT Security Training: Offensive & Defensive Hack Proofing that will allow you to hone your professional skills.

Oct 23 - 26, 2018$3,350.00Nov 20 - 23, 2018$3,350.00Dec 18 - 21, 2018$3,350.00

Linux Training: The Complete Linux Course

The course The Complete Linux Course (Linux Training) is like no other course you have ever taken. This complete Linux course provides a hands-on exploration of the planning, installation, maintenance, management and use of Linux in a production environment. You acquire the skills required to understand the hardware & software aspects of a Linux installation. The discussion includes the kernel, shell commands, security, scripting & system configuration on a production Linux environment. Participants will learn how to create scripts, manage users & groups, and to configure security to count only a few. Training course titled Linux Training: The Complete Linux Course that will allow you to hone your professional skills.

Oct 16 - 19, 2018$3,350.00Nov 13 - 16, 2018$3,350.00Dec 11 - 14, 2018$3,350.00

Linux Training: Shell Scripting Complete

The course Shell Scripting Complete (Linux Training) is a complete exploration of Linux shell scripting. The training includes shell script fundamentals, command structures, operators, scalars, flow control, sub-routines, collections & lists. Students get hands-on experience working with sell scripts that automate just about any aspect of Linux. If you want to write powerful scripts that automate those repetitive tasks, this is the Linux course for you. Training course titled Linux Training: Shell Scripting Complete that will allow you to hone your professional skills.

Oct 2 - 5, 2018$2,775.00Nov 13 - 16, 2018$2,775.00Dec 11 - 14, 2018$2,775.00

IT Security Training: An Introduction to Penetration Testing

The course An Introduction to Penetration Testing (IT Security Training) is an introduction to white hat hacking. The course teaches you how to perform every stage of the hacking process so that you may protect your environment. The training includes tools for information gathering & target scoping, target discover & enumeration, vulnerability mapping & social engineering. You are taught how to use the Metasploit Framework to perform target identification & exploitation so that you may stop it from happening to you. Training course titled IT Security Training: An Introduction to Penetration Testing that will allow you to hone your professional skills.

Oct 3 - 5, 2018$2,250.00Nov 28 - 30, 2018$2,250.00

Linux Training: A Bit of Linux

The course A Bit of Linux (Linux Training) provides a general introduction to Linux. You are given hands-on experience working with the command-line in editing system configuration via text files, system start-up & shutdown, managing files and directories. The training also includes an overview of filesystem management and printing. Training course titled Linux Training: A Bit of Linux that will allow you to hone your professional skills.

Oct 1 - 1, 2018$650.00Oct 29 - 29, 2018$650.00Nov 26 - 26, 2018$650.00

Linux Training: Advanced Administration

The course Advanced Administration (Linux Training) focuses on key Linux functionalities. The course covers partitions, disks & the LVM, file system usage, printing, networking & security. The training also includes hardware management, XEN virtualization, web server configuration, shell scripting & more. Training course titled Linux Training: Advanced Administration that will allow you to hone your professional skills.

Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00

Linux Training: An Introduction to the Operating System

The course An Introduction to the Operating System (Linux Training) provides a general introduction to Linux. The course includes working with the command line, Linux basic commands, shell scripting, working with files & directory, security users & groups and more. The training also includes how to use the graphical environment and how to install, manage & configure software using package management (apt-get & yum). Training course titled Linux Training: An Introduction to the Operating System that will allow you to hone your professional skills.

Oct 3 - 5, 2018$1,675.00Oct 31 - Nov 2, 2018$1,675.00Nov 28 - 30, 2018$1,675.00

Linux Training: CentOS/RedHat Automated System Administration

The course CentOS/RedHat Automated System Administration (Linux Training) introduces Linux shell scripting. This seminar teaches server administrators how to write scripts to automate common administration tasks in a Linux environment. Training course titled Linux Training: CentOS/RedHat Automated System Administration that will allow you to hone your professional skills.

Oct 8 - 8, 2018$650.00Nov 5 - 5, 2018$650.00Dec 3 - 3, 2018$650.00

Linux Training: Core Administration Skills

The course Core Administration Skills (Linux Training) is designed for advance users who are moving to Linux administration. The training covers server installation & configuration and includes file & directory manipulation, daemons, users & groups, backup and networking. Also included are kernel configuration, system monitoring and software management through package managers. Training course titled Linux Training: Core Administration Skills that will allow you to hone your professional skills.

Oct 16 - 19, 2018$2,775.00Nov 13 - 16, 2018$2,775.00Dec 11 - 14, 2018$2,775.00

Linux Training: Essential Concepts for IT Pros

The course Essential Concepts for IT Pros (Linux Training) is an introduction to Linux. The training covers basic file management, basic commands, security implementation, process management & package management to name a few. If you need to become productive in a Linux environment, this training course is the one for you. Training course titled Linux Training: Essential Concepts for IT Pros that will allow you to hone your professional skills.

Oct 10 - 12, 2018$1,675.00Nov 7 - 9, 2018$1,675.00Dec 5 - 7, 2018$1,675.00

Linux Training: Essential Networking

The course Essential Networking (Linux Training) introduces Linux networking concepts. The training includes IPv4 & IPv6 networking, network interface configuration, firewall configuration, Linux networking commands, DNS, DHVP, NFS & more. The course also covers network configuration & security. Training course titled Linux Training: Essential Networking that will allow you to hone your professional skills.

Sep 26 - 28, 2018$1,675.00Oct 24 - 26, 2018$1,675.00Nov 21 - 23, 2018$1,675.00Dec 19 - 21, 2018$1,675.00

Linux Training: Mastering Essential Commands

The course Mastering Essential Commands (Linux Training) teaches new users how work with Linux . The course starts from the ground up, and quickly introduces participants to command line scripting, getting help, file and directory manipulation, I/O redirection, piping & more. The training also includes regular expression, grep & awk and task automating using shell scripting. Training course titled Linux Training: Mastering Essential Commands that will allow you to hone your professional skills.

Oct 9 - 12, 2018$2,775.00Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00

Linux Training: Professional Linux Device Driver Development

The course Professional Linux Device Driver Development (Linux Training) covers everything that you ever wanted to know about Linux Device Driver Development. Starting with the basics, the course quickly proceeds through an in-depth exploration of User Space, Kernel Space, Character Drivers, Block Drivers, Network Drivers & more. The course concludes with an overview of a variety of topics including ALSA, Linux real time solutions & more. Training course titled Linux Training: Professional Linux Device Driver Development that will allow you to hone your professional skills.

Oct 16 - 19, 2018$3,500.00Nov 13 - 16, 2018$3,500.00Dec 11 - 14, 2018$3,500.00

Linux Training: Security & Hacking Complete Course

The course Security & Hacking Complete Course (Linux Training) focuses on Linux security and hacking. Beginning with a Linux security deep-dive, the course discusses the anatomy of a hacker attack on Linux. Every part of the Linux OS is included in the discussion including the kernel, networking components, databases, web servers & more. Training course titled Linux Training: Security & Hacking Complete Course that will allow you to hone your professional skills.

Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00

Linux Training: The Complete Shell Scripting Course

The course The Complete Shell Scripting Course (Linux Training) is an exploration of shell scripting in Linux. The course provides an overview of the benefits of using shell scripts starting with the basics and moving to command structure, operators, scalars, flow control, sub-routines, collections and lists. The training includes all the skills that you need to automate just about any aspect of Linux. Training course titled Linux Training: The Complete Shell Scripting Course that will allow you to hone your professional skills.

Sep 25 - 28, 2018$2,775.00Oct 23 - 26, 2018$2,775.00Nov 20 - 23, 2018$2,775.00Dec 18 - 21, 2018$2,775.00