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. Could you tell me the advantages or disadvantages of implementing this monitoring function? 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
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Reply via email to