HDR over secondary network
Posted in 2005
Topics: High Availability & Replication, Networking & sqlhosts Configuration
HPUX machines, Informix 9.4
We have a primary database server, srvA, and a server we want to use
HDR to back the database up to, srvB.
Both machines are on our primary network, as well as a sync network,
where they have a different set of IP addresses (which are identified
in the hosts files as srvA-sync and srvB-sync).
We would like to do the HDR over the sync network.
If I set the sqlhosts files to do HDR over the primary network, it
works fine.
If I set the sqlhosts files to do HDR over the sync network, it only
works if srvB is not attached to the primary network.
if srvB is attached to the sync network, I get the errors:
11:53:26 DR: new type = primary, secondary server name = srvB-db
11:53:26 DR: Cannot connect to secondary server
11:53:26 DR: Turned off on primary server
11:53:35 DR: Trying to connect to primary server = srvA-db
11:53:35 DR: Cannot connect to primary server
11:53:35 DR: Turned off on secondary server
What is the trick to getting HDR to work over the secondary network?
MMarks wrote:
>
> HPUX machines, Informix 9.4
>
> We have a primary database server, srvA, and a server we want to use
> HDR to back the database up to, srvB.
>
> Both machines are on our primary network, as well as a sync network,
> where they have a different set of IP addresses (which are identified
> in the hosts files as srvA-sync and srvB-sync).
> We would like to do the HDR over the sync network.
>
> If I set the sqlhosts files to do HDR over the primary network, it
> works fine.
> If I set the sqlhosts files to do HDR over the sync network, it only
> works if srvB is not attached to the primary network.
>
> if srvB is attached to the sync network, I get the errors:
> 11:53:26 DR: new type = primary, secondary server name = srvB-db
> 11:53:26 DR: Cannot connect to secondary server
> 11:53:26 DR: Turned off on primary server
>
> 11:53:35 DR: Trying to connect to primary server = srvA-db
> 11:53:35 DR: Cannot connect to primary server
> 11:53:35 DR: Turned off on secondary server>
> What is the trick to getting HDR to work over the secondary network?
>
Just to get the obvious out of the way ... is there a route defined between
the two networks?
Art S. Kagel
On Thu, 22 Dec 2005 14:43:04 -0500, "Art S. Kagel" <kagel@bloomberg.net> wrote: >Just to get the obvious out of the way ... is there a route defined between >the two networks? > Yes, but I don't know if it's relevant. We want the HDR to function entirely over the secondary network just as it does when the primary network does not exist.
MMarks wrote:
> On Thu, 22 Dec 2005 14:43:04 -0500, "Art S. Kagel"
> <kagel@bloomberg.net> wrote:
>
>
>
>>Just to get the obvious out of the way ... is there a route defined between
>>the two networks?
>>
>
>
> Yes, but I don't know if it's relevant. We want the HDR to function
> entirely over the secondary network just as it does when the primary
> network does not exist.
OK, post the sqlhosts entries for the two servers and the exact onmode
command you are trying to use to initiate HDR.
Art S. Kagel