Petardas

Oracle University | Contact Us: 001-800-514-06-97Ð

MySQL Cluster
Duration: 3 Days What you will learn In the MySQL Cluster course, you will learn the important details of clustering that you willneed 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 betterunderstanding 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

Related Training RequiredPrerequisites Basic knowledge of database concepts and SQL Have previously worked with a MySQL Server instance and database Be able to install MySQL Have working knowledge of MySQL architecture

SuggestedPrerequisites Can state general knowledge of hardware and OS Can use MySQL tools to connect to the MySQL Server

Course Objectives Explain the concepts of MySQL Cluster in detail Describe thedifferent 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 thedifferent 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 isnecessary Know how to upgrade cluster components and configuration settings

Copyright © 2012, Oracle. All rights reserved.

Page 1

Explain how node failure is detected and handled in the clusterDescribe 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 thedata 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

Course Topics...