Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a four server cluster with Oracle Clusterware managing 4 MySQL instances on them. On failure Clusterware will move the MySQL instance to another server.

I am on Proliant servers and also have ASR running. Recently I had a failover where ASR hard rebooted a server and Clusterware had to step in to bring up the database on another server.

I'm quite open to disabling ASR if necessary.

What production configurations should I run with ASR and Clusterware?

share|improve this question
add comment

1 Answer

What was the cause for the ASR? Given that the watchdog timer caught the system crash, do you have anything in the HP IML log indicating the root problem?

I typically leave the ASR functionality on, even making a point to reduce the ASR timeout to 5 minutes from the default 10 minute setting. What is the desired outcome of your setup? An ASR indicates a larger problem with the OS/hardware. Are you saying that you want the server to stall and/or stay off so the other systems in the cluster take over? Or is it okay if the system reboots?

share|improve this answer
    
It is fine if the server reboots. I was thinking perhaps it would be easier if Oracle Clusterware does the failover before the machine fails as MySQL replication often fails on an ASR forced restart but not when Oracle moves the MySQL instance. I'll check the IML log. –  Stewart Robinson Jan 28 '11 at 9:22
    
If that's the case, you can disable the ASR or maximize the ASR timeout (such that the Clusterware picks up the node failure first). But fix your hardware either way. ASRs should not be common. –  ewwhite Jan 28 '11 at 17:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.