Sean Hull

DRBD and MySQL - An HA Match Made In Heaven

Date: This event took place live on January 19 2010

Presented by: Sean Hull

Duration: Approximately 60 minutes.

Cost: Free

Questions? Please send email to

Description:

DRBD has grown in popularity as an excellent low-cost high availability solution for MySQL. It provides synchronous replication of your data without MySQL having to worry too much about the details. Combined with Linux Heartbeat, and you have automatic failover as well. By using this Operating System level replication, you avoid some of the problems of MySQL's statement based replication, data discrepencies between your nodes, and configuration file complexity. No more failing slave nodes!

This presentation will cover:

  1. Introduction
  2. What is DRBD
  3. How does MySQL Use DRBD?
  4. Advantages & Disadvantages to MySQL Replication?
  5. Virtual Machine Setup
  6. DRBD Setup
  7. DRBD Testing
  8. MySQL Setup & Configuration
  9. Conclusion
  10. Links & Further Reading

About Sean Hull

Sean Hull is a business and technology consultant, author and speaker. He is the founder and senior consultant at Heavyweight Internet Group in New York and has worked as a database consultant and expert for ten years. He is the author of "Oracle and Open Source" (O'Reilly) and his articles appear on Oracle Technology Network, Database Journal, DBA Zine, ChangeThis.com, and many others. Using techniques, technologies, and perspectives discussed in his book, articles, and seminars, he has taken his career into exciting areas. He has served as Technology Consultant, Project Manager, CEO, and mentor with a background in programming, systems integration & administration, project development and management.