Tel: UK 0845 757 3888 | Ireland: 01 284 6796
MySQL Cluster
Course type Essentials (What does this mean?)
| Course title | MySQL Cluster |
|---|---|
| Delivery method |  Classroom |
| RRP | £1533 exc. VAT |
| Days/Duration | 3 |
| Code | SQL4302 |
Secure online payment
- view dates / book course
- course description
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
Tabernacle Street, EC2 |- |- |18 |- 
Location Sep Oct Nov Dec view earlier dates Tabernacle Street, EC2 |- |- |- |12 Tabernacle Street, EC2 location information and directions
18 Jul 5 or more places available £1,533 exc VAT 12 Dec 5 or more places available £1,533 exc VAT MySQL Cluster training in Tabernacle Street, EC2
Special Notices
Please note that Oracle courses running at London training centres are subject to a 10% surcharge.
Overview
-
Have previously worked with a MySQL Server instance and database
-
Have working knowledge of MySQL architecture
-
Be able to install MySQL
-
Can state general knowledge of hardware and OS
-
Can use MySQL tools to connect to the MySQL Server
- Basic knowledge of database concepts and SQL
Suggested prerequisite course : MySQL for Database Administrators (SQL4502)
In the MySQL Cluster course, you will learn the important details of clustering that you will need to understand to get started with MySQL Cluster, how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes and provide a better understanding of the internals of the cluster.
Students that can benefit from this course: Experienced database users who want an in-depth understanding of MySQL Cluster.
Delegates will learn how to
-
Explain the concepts of MySQL Cluster in detail
-
Describe the different nodes in MySQL Cluster and their purposes
-
Explain how the data is distributed and replicated in the MySQL Cluster
-
Install all the different nodes used in the MySQL Cluster
-
Start and stop the different nodes as needed
-
Understand how the different configuration files work and be able to configure all possible types of clusters
-
Put the cluster in single user mode, and understand when this is necessary
-
Know how to upgrade cluster components and configuration settings
-
Explain how node failure is detected and handled in the cluster
-
Describe how node restart works internally
-
Explain how system restart works and when this type of restart is needed
-
Take backups and restore the data from backups
-
Describe the internal parts of the data nodes
-
Explain how the different types of data scans are performed
-
Explain the difference between the different index types
- Configure the cluster for optimal performance
Related blogs
Did you have a satisfactory course?
Posted by Phil Stirpe on 25 May 2012
I have written and delivered training courses for many years and in all that time there has always been some form of evaluation at the end of the course. Although there are several questions on the current QA evaluation form, the most important is Overall Satisfaction.
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
