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

Reply via email to