Tuesday, February 3, 2009

MySQL Performance Tuning and HA

MySQL Training Special Offer

For those of you looking to improve your Performance Tuning and/or High Availability skills, book on either of the training courses below before Friday, February 6th to qualify for a 10% discount.

MySQL Performance Tuning - 4 Days
March 2nd, London

  • Do you need to manage an increasing amount of data in your MySQL applications?
  • Do you want to monitor, diagnose problem areas and tune MySQL for optimal performance?
  • Do you want to write queries that take advantage of the MySQL performance enhancements dealing with queries and indexing?
  • Do you want to evaluate the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance?

Then MySQL Performance Tuning is the class running March 2nd is for you! The MySQL Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating and tuning. You will get to evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts. The cost of this course is £1199.



MySQL High Availability - 3 Days
February 23rd, London

Do you wish to develop your understanding around the different high availability options including clustering and replication solutions within MySQL? If so then our upcoming 3 day MySQL High Availability course running on February 23rd in London is for you.

This course will provide the tools required to make the decision around what high availability solution is appropriate and how to analyse the performance impact of a HA decision. The cost of course is £899 - not only will this course enable you to implement a system with the correct design but you should be able to do the following….

  • 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
  • Setup a basic MySQL cluster instance
  • Discuss how to integrate MySQL cluster and replication
  • 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
  • Develop a plan to implement the appropriate high availability solution

To register on one or more of the above training courses and secure your discount please visit http://www.mysql.com/training/ call 0845 399 1124 or email uk-sales@mysql.com

Best regards,
MySQL


Copyright � 2009 MySQL AB| www.mysql.com


Please click here to unsubscribe

Your cOmment"s Here! Hover Your cUrsOr to leave a cOmment.


Subscribe to: Post Comments (Atom)