[Linux-HA] Implement OCF MySQL Monitoring function or not?

[Andrew Beekhof]

On Feb 7, 2008, at 10:08 AM, Lino Moragon wrote:

> Hi list,
> I'm running a HA 2 node active / passive cluster with drbd and mysql.
> I was told about the ocf monitoring function of the yet available  
> mysql ocf script.

well if its an OCF script it needs to implement some kind of  
monitoring - its mandatory

whether the monitoring it does is any good is another question...

> Could you tell me the advantages or disadvantages of implementing  
> this monitoring function?

its not optional :-)

>
> I mean surely it does have benefits, but what if I my php  
> webapplications e.g. generate too much load, too large and complex  
> queries and the timeout value exceeds?
> Then the server would restart or failover and then that would repeat  
> itself on and on and my ha-cluster wouldn't be a hacluster anymore.
> Have you any experience what possible things could happen to a mysql  
> server and what would be the reasons for hang-up, crash, etc...?
> Problem is, I can't estimate the load or amount of queries the  
> application will generate, as I don't have much experience in this  
> field and the DBs will grow over time.
> Should I implement ocf monitoring or rather not?
>
> I'm very thankful for any advice or hints about this matter, where  
> to get more information, or personal experiences with the stability  
> of mysql servers.
> Thanks
> Lino
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems