Emmanuel, I don't understand. This seems to be working very well for me:
primitive p_mysqld lsb:mysql order o_mysqld inf: cl_fs_share p_mysqld rsc_defaults resource-stickiness="100" cl_fs_share is an OCFS2 filesystem but, since I never have p_mysqld running on more than one node, it could actually be any kind of filesystem. Is there something "not good" about relying on lsb::mysql? -- Art Z. On 12/04/2012 07:31 AM, Emmanuel Saint-Joanis wrote: > Everything (Apache+MySql) on the Master (Primary), plus a Slave (Secondary) > ready to run in case of Master failure, seems to be the good recipe. > But I'm not sure that a good Stateful Resource Agent for MySQL is > available, like the very good one from Takatoshi Matsuo (for Postgres). > > 2012/12/4 Art Zemon <a...@hens-teeth.net> > >> Folks, >> >> I am building a high availability web hosting platform which will include >> a pair of web servers with an OCFS2 shared filesystem and a MySQL database >> server with a backup (using a DRBD-based filesystem instead of MySQL >> replication). Does this sound like one cluster or two (one for the web >> servers and a second for the database servers)? >> >> Thanks, >> -- Art Z. >> >> _______________________________________________ >> Linux-HA mailing list >> Linux-HA@lists.linux-ha.org >> http://lists.linux-ha.org/mailman/listinfo/linux-ha >> See also: http://linux-ha.org/ReportingProblems > _______________________________________________ > Linux-HA mailing list > Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems -- Art Zemon, President Hen's Teeth Network <http://www.hens-teeth.net/> for reliable web hosting and programming (866)HENS-NET / (636)447-3030 ext. 200 / www.hens-teeth.net _______________________________________________ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems