In this episode we talk about the MySQL Master High Availability Agent, aka MHA.
There will be a "MySQL and Friends" devroom at FOSDEM 2012. The dev room is scheduled for Sunday 5th February 2012, whole day. If you are interested to give a talk, please submit it before December 26th through the submission form. You can read the original announcement by Frédéric Descamps.
Debian packages are now available starting with MySQL 5.5.18. There are no Debian packages for the recent builds of MySQL 5.1.
MySQL Master HA Agent
Yoshinori Matsunobu's announcement of MHA's availability.
MHA configuration details on the project's wiki page - there are tutorials and reference guides.
Gerry's mini how-to article with some considerations about the definition of MySQL and Linux accounts and permissions. Note: The documentation uses 'root' for both, but we prefer to use 'mysql' user for the OS and a specific user for accessing the MySQL instances remotely.
Github issues that add options for new use cases:
supporting a multi-master configuration
avoid running CHANGE MASTER TO on the promoted slave
monit tool for monitoring.
SkySQL offers support for MHA through a partnership with Matsunobu.
This week’s ear candy is errata:
We made a mistake in last week's ear candy. my_print_defaults outputs *only* the contents of the .cnf files and not the defaults.
The defaults can be checked running "mysqld --verbose --help" and the current options for a running server with "mysqladmin variables"
At the Movies
This week in at the movies we present Jeff Yemin of MTV networks speaks about MongoDB at MTV Networks at the September 2011 Boston MySQL User Group. http://www.youtube.com/watch?v=DItv2eTjb3E
Where you can see us
Gerry will be at the January Seattle MySQL User Group on Monday January 2nd from 7 - 9 pm.
Sheeri will be at the January Boston MySQL User Group on Monday January 7th from 7 - 9 pm, where we will feature Tim Callaghan (yes, there is a relation) of Tokutek speaking about "Fractal Tree Indexes - Theoretical Overview and Customer Use Cases"