Unsolved

This post is more than 5 years old

345

September 20th, 2007 08:00

"Communication" between two resource groups?

Hi

We have a request from a customer that wants to run two installations of EMC autostart.
1. Server pair "A" Two servers (dataserver) with Win2k3 and SQL server with EMC autostart.
2. Server pair "B". Two servers (application and terminal services) with a software using the SQL server in the other server (A). This server pair is also running EMC autostart.

The problem is that if the SQL server would failover / relocate to the other server the application running on "B" would need to be restarted to function properly (it does not handle that the SQL server i gone for 1-2 minutes while the relocation is taking place).
So the question is, how do we make sure that the resource group on Server "B" is restarted if a relocation is taking place on "A". Could we run a script (or do something else) on server A that will make server B restart / relocate the resource group?

The 4 servers might be in the same Autostart domain it that is relevant.

Regards
Arild

45 Posts

September 20th, 2007 13:00

I've done this with Oracle on AIX.

I think the easiest way to do this one windows is to write a script using Perl with the built-in autostart functions. So when the DB resource group comes up it would check the status of the Application resource group. If the application resource group was already online it would:

-take it offline
-verify that it was down
-start up the database
-bring the application resource group back online.

Also, I had written a script for the application RG to check and see if the DB RG was up. IF it wasn't, it posted a message to the Autostart event log and waited for 10 seconds before it tried it again. After 15-20 cycles of this it would stop completely. That way the application would never start up unless the database was up first.

It's been over a year since I had to write anything like that and I lost the def files when my external drive crashed. :) Otherwise I could give you some examples of the code. You shouldn't need to stray out of the programmers guide though.

To make things easier you want to make sure that they ARE ALL IN THE SAME DOMAIN as you have stated.

September 24th, 2007 02:00

Hi Ryan

Thanks for the reply.

We'll try to figure it out.

Arild

0 events found

No Events found!

Top