OurSQL Episode 69: Replication Secret Agent

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.

Meet the MySQL Experts Podcast

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.

The Google code page for MHA, including downloads.

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.

The new Percona replication manager will combine Pacemaker with MHA

Ear Candy
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"

Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast