yep, you can go with it, but as I see you get enough with a ``sleeping slave`` with DRBD in Master/Slave mode, so you can't mount the FS on the slave, therefore MySQL only wakes up after transition when `something bad happens`. I prefer the solution Master MySQL with Hot-spare on the other server, that enables you to connect on a Read/Only database, which can promote really fast when needed. And for that you need a Stateful Agent, yet to write I guess.
2012/12/4 Art Zemon <[email protected]> > 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 <[email protected]> > > > >> 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 > >> [email protected] > >> http://lists.linux-ha.org/mailman/listinfo/linux-ha > >> See also: http://linux-ha.org/ReportingProblems > > _______________________________________________ > > Linux-HA mailing list > > [email protected] > > 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 > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems > _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
