Skip navigation links

Contact Sales

USA/Canada - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA/Canada - Subscription Renewals: +1-866-221-0634

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 61 48 95
Sweden: +46 730 207 871
Benelux: +31 6 25003558
Italy: +39 06-99268193
Israel: +31 6 25003558
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191

Australia/NZ: +61 2 42314328
Asia Pacific: +81 3 5843 1140

Contact Us Online »

MySQL Newsletter - Subscribe Today!

MySQL High Availability

FAQ

Sun Training Classes »

  • Do you need to ensure that the MySQL database will experience a minimal loss of availability over time?
  • Do you want to increase the availability for MySQL?
  • Do you need to be able to present a MySQL high availability business case to the managerial positions which will make the final decision?

Then you will find MySQL High Availability is the course for you! This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

At the completion of this course, you should be able to:
  • Describe the implementation of MySQL replication
  • Setup a basic master-slave replication environment
  • Understand when a master-master or circular replication environment is possible
  • Set up a master-master and circular replication system
  • Monitor a MySQL replication setup
  • Use MySQL replication for advanced tasks such as software upgrades to increase availability
  • Analyze the design and limitations of MySQL cluster
  • Setup a basic MySQL cluster instance
  • Discuss how to integrate MySQL cluster and replication
  • Analyze how it is possible to setup MySQL with a shared-disk cluster solution
  • Know when you can do active-active and active-passive shared-disk setups
  • Understand different shared-disk cluster setups depending upon operating system choices, such as LVM, Windows Cluster Agent, Veritas Cluster Agent, etc..
  • Understand the differences with third-party clustering solutions, such as DRBD or m/cluster
  • Explore the impact of different backup solutions on highly available solutions
  • Identify the effects of different maintenance tasks and how to maintain high availability while performing these operations
  • Minimize downtime due to these maintenance tasks
  • Describe the future development path of the different solutions
  • Develop a plan to implement the appropriate high availability solution
  • Analyze the performance impact of a high availability decision
  • Recognize the business decision side of the solutions, such as cost and risk
Who should Attend
  • Experienced database administrators and system architects
Prerequisites
Students who wish to attend this course, should have attended the MySQL 5.0 for DBAs course or have similar knowledge
Format
  • Instructor led, with extensive 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 High Availability
LocationDatesPrice  
Zaragoza25 - 27 Nov 2009899 EURRegisterQuestions?
Berlin30 Nov - 2 Dec 20091099 EURRegisterQuestions?
Vancouver21 - 23 Dec 20091499 USDRegisterQuestions?
Lyon21 - 23 Dec 20091199 EURRegisterQuestions?
Santa Clara6 - 8 Jan 20101499 USDRegisterQuestions?
Paris18 - 20 Jan 20101199 EURRegisterQuestions?
Lyon18 - 20 Jan 20101199 EURRegisterQuestions?
Milan19 - 22 Jan 20101199 EURRegisterQuestions?
Chicago25 - 27 Jan 20101499 USDRegisterQuestions?
Paris8 - 10 Feb 20101199 EURRegisterQuestions?
Lyon8 - 10 Feb 20101199 EURRegisterQuestions?
Hamburg8 - 11 Feb 20101099 EURRegisterQuestions?
London15 - 17 Feb 2010899 GBPRegisterQuestions?
Vancouver16 - 19 Feb 20101499 USDRegisterQuestions?
Roma3 - 5 Mar 20101199 EURRegisterQuestions?
Zaragoza10 - 12 May 2010899 EURRegisterQuestions?