dbTalk Databases Forums  

Failover question

comp.databases.informix comp.databases.informix


Discuss Failover question in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Scott Newton
 
Posts: n/a

Default Failover question - 08-03-2010 , 08:56 PM






Scenario: Client has a primary server and an RSS server and the primary goes down. The RSS server is changed to standard to allow clients to continue to connect.

Is there a way of bring up the old primary and revert the new primary back to an RSS server without major interruptions to the client connections? I can do it by rebuilding the RSS server but I was wondering if there was a better way.

Thanks

--
Regards
Scott Newton
R&D Solutions Specialist

< Integral >< Axon >

DDI: +64 09 302 2788
Fax: +64 09 523 8810

Axon House, 414-422 Khyber Pass Road, Newmarket 1023, Auckland
PO Box 9824, Newmarket 1023, Auckland

This correspondence is confidential, is intended for the named recipient(s)only, and may contain information that is confidential or subject to legalprofessional privilege. If you are not the intended recipient you must notuse, disclose, distribute, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails. Thank you.

Reply With Quote
  #2  
Old   
Art Kagel
 
Posts: n/a

Default Re: Failover question - 08-04-2010 , 05:07 AM






The standard method is to bring up the old primary, make it an RSS secondary
to the new primary, then, once it has caught up, reverse them making the old
primary primary again and the original RSS secondary secondary again. The
second part will have to be done during a maintenance window as making the
reversal will force out any connected sessions.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Tue, Aug 3, 2010 at 9:56 PM, Scott Newton <
Scott.Newton (AT) integralgroup (DOT) co.nz> wrote:

Quote:
Scenario: Client has a primary server and an RSS server and the primary
goes down. The RSS server is changed to standard to allow clients to
continue to connect.

Is there a way of bring up the old primary and revert the new primary back
to an RSS server without major interruptions to the client connections? I
can do it by rebuilding the RSS server but I was wondering if there was a
better way.

Thanks

--
Regards
Scott Newton
R&D Solutions Specialist

Integral >< Axon

DDI: +64 09 302 2788
Fax: +64 09 523 8810

Axon House, 414-422 Khyber Pass Road, Newmarket 1023, Auckland
PO Box 9824, Newmarket 1023, Auckland

This correspondence is confidential, is intended for the named recipient(s)
only, and may contain information that is confidential or subject to legal
professional privilege. If you are not the intended recipient you must not
use, disclose, distribute, copy or retain it. If you have received it in
error please immediately notify me by return email and delete the emails.
Thank you.
_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.