Manual Switch Primary , Secondary while RSS exist
ABeMie asked how to manually switch primary and HDR secondary roles on Informix 12.14 while an RSS node exists. Art Kagel said the procedure is the same, as the new primary contacts the RSS nodes. David Williams and Kirit Rana advised letting the RSS join the new primary before bringing the old primary up as secondary, or stopping the RSS during the switch.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi
I have a client running IBM Informix 12.14 in RedHat 7.6.
They have IDS Primary & IDs Secondary in HQ Data Centre while IDS RSS in DRC Data Centre.
I didnt setup Control Manager. All this while I'm using manual via onmode command.
I always refer Art Kagel document how to swtch from PRI -SEC for failover and SEC-> for fallback. But that for only 2 server.
If I have RSS how do I switch PRI become Secondary and Secondary become PRI by expecting RSS still remain.
Can somebody provide me the steps.
Need an expert advise.
------------------------------
ABeMie
------------------------------
#Informix
ABeMie: It's the same whether you have RSS secondaries or not. When the HDR secondary takes over as primary it will reach out to the RSS secondaries and make the connection basically saying "Yo, dude, talk to me now!" All is well. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Hi, One thing I will mention is if you stop the primary for any reason then wait for the RSS nodes to join the cluster with the new primaary BEFORE bringing up the old Primary as the HDR. Otherwise the RSS can remain attached to the old primary (which is now the HDR) and will not witch over to the new primary, This means they will not receive/apply new log records! Regards, David. ------------------------------ David Williams ------------------------------
ABeMie
Absolutely agree with @David Williams; Do not wait for your
RSS
node to
checkpoint
before you convert your original Primary into your new HDR Secondary if you do not want to untangle spaghetti.
If you think you will
not
be able to complete the switch before the
CKPTINTVLtime configured in the
RSS
node ONCONFIG file has elapsed, then it is probably best to bring the RSS node down while you flip the Primary and HDR Secondary nodes and bring it back up after a successful switch.
------------------------------
Kirit Rana
------------------------------