Skip navigation links

Contact Sales

USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410

Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 38 72 00
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191

Asia Pacific: +81 3 5918 7507

Contact Us Online »

Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »

MySQL Cluster for High Availability

FAQ

  • Do you wonder what MySQL Cluster is all about?
  • 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.

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 should Attend
  • 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:
5.0, 5.1
Duration
3 Days.

Upcoming Sessions

MySQL Cluster for High Availability
LocationDatesPrice  
Paris16 - 18 Jun 20081199 EURRegisterQuestions?
Beijing23 - 25 Jun 2008749 USDRegisterQuestions?
New York25 - 27 Jun 20081499 USDRegisterQuestions?
Lyon15 - 17 Jul 20081199 EURRegisterQuestions?
Paris15 - 17 Jul 20081199 EURRegisterQuestions?
München21 - 23 Jul 20081099 EURRegisterQuestions?
Cupertino28 - 30 Jul 20081499 USDRegisterQuestions?
Washington DC28 - 30 Jul 20081499 USDRegisterQuestions?
Lyon8 - 10 Sep 20081199 EURRegisterQuestions?
Paris8 - 10 Sep 20081199 EURRegisterQuestions?
Beijing22 - 24 Sep 2008749 USDRegisterQuestions?
Paris22 - 24 Sep 20081199 EURRegisterQuestions?
Lyon20 - 22 Oct 20081199 EURRegisterQuestions?
Paris20 - 22 Oct 20081199 EURRegisterQuestions?
Beijing24 - 26 Nov 2008749 USDRegisterQuestions?