Writing Application Code for MySQL High Availability


Even with a state of the art High availability solution for MySQL, failure conditions can be undesirable if the application behaves improperly This webinar explores the various ways you can build your application for MySQL High Availability to meet your deliverables.

This talk will explore many concerns to keep in mind when developing an application for MySQL HA including:

  • Handling DB errors
  • Finding a master that is read-only
  • Deadlocks and replication conflicts
  • Database not available
  • When to reconnect and when to give up (and when to core dump)
  • Coping with Latency sensitivity
  • Picking which tier to fail over
  • Read / Write splitting
  • Detecting and managing Slave lag