Dear guys, I have set up a MySQL Master/Slave replication and tried to make it HA using corosync/pacemaker. I used the Mysql Resource Agent currently provided by Debian Wheezy and set up the corosync primitives as mentioned in the examples[1]. When migrating the mysql resource from one node to the other, the mysql resource agent didn't handle the slaves at all. As I inspected the code of the mysql resource agent, I figured out, that all the slave handling is done in the mysql_notify function of the resource agent. To enable the multi state resource ms_mysql to send notifications to the mysql resource agent, I added:
ms ms_mysql p_mysql \ meta clone-max=3 \ *meta notify="true"* Now the MySQL replication slaves get started/stopped as expected. You may add this parameter to your documentation[2], so other users don't have to figure it out themselves :-) cheers Tom -- unixum Tom Hutter Hufnertwiete 3 D-22305 Hamburg Telefon: +49 40 67 39 21 52 mobil : +49 174 400 24 16 E-Mail: [email protected] www.unixum.de Steuer-Nr.: 43/102/01125 Geschäftsführung: Tom Hutter -------- [1] http://www.linux-ha.org/wiki/Mysql_%28resource_agent%29 [2] http://www.linux-ha.org/wiki/Mysql_%28resource_agent%29#MySQL_master.2Fslave_replication _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
