Question on HDR
Jack Papa asked whether an HDR secondary takes over as primary immediately if the primary fails, and whether it resyncs after a network outage. Jarrod Teale said it depends on DRAUTO and version and pointed to the manual. Nilesh Ozarkar said set DRAUTO=2 for automatic failover, or run onmode -d primary for manual failover. Jack thanked them.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, Just a question on HDR of Informix.. The scenario is the DB primary server went down. The secondary server is up and running. The replication is fine before the primary shuts down. Here are the questions: 1. Is the Secondary server will function right away as the Primary? If not, how to make it as the primary server?. 2. If network fails, will the secondary server will automatically sync with the primary server once the network is up?
Jack, It depends on what you have DR_AUTO set to and what version of Informix you are running. Here is the link to the guide for 11.50 http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.adre f.doc/ids_adr_0056.htm?resultof=%22%44%52%41%55%54%4f%22%20%22%64%72%61% 75%74%6f%22%20 As for the network - check the "attention" bit at the bottom. :) Jarrod Teale Team Lead - Manufacturing Execution Systems Automation & Process Control Group NZ Technical Fonterra NZ -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of JACK PAPA Sent: Wednesday, 21 October 2009 3:57 p.m. To: ids@iiug.org Subject: Question on HDR [17643] Hi All, Just a question on HDR of Informix.. The scenario is the DB primary server went down. The secondary server is up and running. The replication is fine before the primary shuts down. Here are the questions: 1. Is the Secondary server will function right away as the Primary? If not, how to make it as the primary server?. 2. If network fails, will the secondary server will automatically sync with the primary server once the network is up? ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.
ids-bounces@iiug.org wrote on 10/20/2009 09:57:03 PM:
> [image removed]
>
> Question on HDR [17643]
>
> JACK PAPA
>
> to:
>
> ids
>
> 10/20/2009 09:58 PM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hi All,
>
> Just a question on HDR of Informix..
>
> The scenario is the DB primary server went down. The secondary server is
up
> and running. The replication is fine before the primary shuts down.
>
> Here are the questions:
>
> 1. Is the Secondary server will function right away as the Primary? If
not,
> how to make it as the primary server?.
Depends on whether you want manual or automatic failover.>
For automatic failover you will have to configure DRAUTO=2,
then secondary server will become primary automatically.
For manual failover, you will have to execute
'onmode -d primary <secondary>' command.
Refer to
http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.admin.doc/id
s_admin_0956.htm
for more details.
>
> 2. If network fails, will the secondary server will automatically sync
with
> the primary server once the network is up?
Yes>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thanks a lot.