Case Study (JetAir): Dramatically increasing uptime with MHA

With
Joffrey Michaie (SkySQL)
Peter Vandenberghe (JetAir)
Yoshinori Matsunobu

Jetair is the Belgian branch of TUI Travel (the largest tourism group in the world) and the market leader in the Belgian tourist industry. Its offer comprises holidays by air, holidays by car and city trips under the brand names Jetair, VIP Selection, Sunjets.be and VTB Reizen.
Seeking better HA mechanisms, JetAir chose MHA to make better use of their existing hardware and more use of their existing server install base.

In this 45-minute talk, we will explore
-- how and why DRBD/Heartbeat was gradually switched for MHA,
-- how MHA for MySQL is now used internally (hardware maintenance, MySQL Upgrades) and
-- some of the pitfalls and key lessons learned in the process, notably issues around
-- -- persistent connections,
-- -- user permissions,
-- -- master-master-slave scenario.