Do you want to ensure the high availability of your data?
Are you sure your MySQL Cluster is configured optimally?
Do you want to learn all the tips and tricks in running a highly available MySQL Cluster?
Then MySQL Cluster for High Availability is for you! An Authorized MySQL instructor will teach you 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.
Skills Gained
At the completion of this course, you should be able to:
Describe the fundamentals of cluster technologies
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
Who Can Benefit
Experienced database users who want an in-depth understanding of MySQL Cluster.
Prerequisites
Students who wish to attend this course, should have attended the MySQL 5.0 for DBAs course or have similar knowledge, demonstrated through e.g. MySQL DBA certification:
Basic knowledge of database concepts and SQL
Be able to install MySQL
Have previously worked with a MySQL Server instance and database
Have working knowledge of MySQL architecture
Can use MySQL tools to connect to the MySQL Server
Can define table structures, index structures, constraints and other objects
Can state general knowledge of hardware and OS
Format
Instructor led, with hands-on lab exercises
Each student will be provided with their own computer
Applies to MySQL Version:
Instructor led, with hands-on lab exercises
Each student will be provided with their own computer
Code:
MySQL-CLUST-HA
Length:
3 days
Type:
Instructor-Led
Certified By:
MySQL
Tuition:
$1,499
This course is taught by Certified MySQL instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
An Authorized MySQL instructor will teach you 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.
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
