Switching HDR / Primary
A DBA on IDS 11.70.FC7 (Solaris) with an HDR pair plus RSS nodes asked whether switching roles via "onmode -d make primary <server>" differs from the shipped hdrmkpri.sh/hdrmksec.sh scripts. Answers: both work; the scripts require shutdowns/restarts and cluster rebuild steps, while make primary promotes the secondary without restarting it and reattaches all secondaries, doing extra internal coordination (it's what Connection Manager uses), so it was recommended for manual or scripted failover; Connection Manager was suggested for automatic failover, and checking 11.70.xC8 HA-related APARs was advised. A follow-up question on bringing the old primary up standalone, detached from replication, was answered by the poster himself: "oninit -S" starts it as a standard server with HA replication disabled.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
with HDR and a few RSS nodes. I read the docs and available literature on
HDR/RSS.
When switching the HDR and Primary servers, is there any difference between
using the "onmode -d make primary <hdr_server>" command and using the
hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
I tested various scenarios and both seem to work well. Any difference or
is there a recommendation of when to use which set of commands?
Thank You,
--Dave
--089e01183938fe68540536f7b1e2
I can't say I'm familiar with the script you mention but based on what you
wrote, here's what I can tell you. First I would strongly encourage use of the
connection manager. It will handle client connections and failover for you.
Second, the onmode -d makeprimary does two important things: promote a new
primary and reattatches all the secondaries at once. *Typically*, this is only
executed in a maintenance period when you need to work on the server. For real
life production settings, you want the connection manager handling failover.
It can detect a failure and readjust the cluster in less time than it takes
you to realize a problem has occurred.
What little you've shown of the script it appears you have to rebuild the
cluster from scratch by defining a new primary, redefining the secondaries,
then recovering them into the cluster. When a node is converted to standard
mode, it loses all connections and knowledge of the secondaries. Recovering
the secondaries takes time and is unnecessary when the -d makeprimary command
is available..
Carlton Doe
dbaresrc@xmission.com
Sent from my iPad -- typos and all
> On Jul 6, 2016, at 8:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
>
> Hi,
>
> We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> with HDR and a few RSS nodes. I read the docs and available literature on
> HDR/RSS.
>
> When switching the HDR and Primary servers, is there any difference between
> using the "onmode -d make primary <hdr_server>" command and using the
> hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
>
> I tested various scenarios and both seem to work well. Any difference or
> is there a recommendation of when to use which set of commands?
>
> Thank You,
>
> --Dave
>
> --089e01183938fe68540536f7b1e2
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Either way. Using the hdrmkpri.sh and hdrmksec.sh scripts is the easier way
to do it. If you want to use onmode manually, you either have to go through
the steps that the scripts do (ie using onmode -d primary and onmode -d
secondary with shutdowns and restarts etc) or you can use onmode -d make
primary .. on the secondary which will shutdown the primary and make the
secondary primary then restart the primary with -PHY (which prevents fast
recovery) then run onmode -d primary on the original primary to make it
secondary to the promoted secondary.
Easier to:
1. shutdown the primary - onmode -ky
2. run "hdrmkpri.sh orig_primary" on the original secondary
3. run "hdrmksec.sh orig_secondary" on the original primary
4. oninit on the promoted new primary to start it
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Wed, Jul 6, 2016 at 9:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
> Hi,
>
> We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> with HDR and a few RSS nodes. I read the docs and available literature on
> HDR/RSS.
>
> When switching the HDR and Primary servers, is there any difference between
> using the "onmode -d make primary <hdr_server>" command and using the
> hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
>
> I tested various scenarios and both seem to work well. Any difference or
> is there a recommendation of when to use which set of commands?
>
> Thank You,
>
> --Dave
>
> --089e01183938fe68540536f7b1e2
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11444958cb3f0e0536f801fe
Hi Carlton,
Thank you. The hdrmkpri.sh script is in the ${INFORMIXDIR}/bin script and
is an IBM script included with the engine referenced in the docs here
http://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/i
ds_admin_0949.htm.
I will take a look at the connection manager, though due to the nature of
the environment and app servers, we don't want any auto switchovers to
occur at this point.
Thank You,
--Dave
On Wed, Jul 6, 2016 at 9:55 AM, Carlton Doe <dbaresrc@xmission.com> wrote:
> I can't say I'm familiar with the script you mention but based on what you
> wrote, here's what I can tell you. First I would strongly encourage use of
> the
> connection manager. It will handle client connections and failover for you.
>
> Second, the onmode -d makeprimary does two important things: promote a new
> primary and reattatches all the secondaries at once. *Typically*, this is
> only
> executed in a maintenance period when you need to work on the server. For
> real
> life production settings, you want the connection manager handling
> failover.
> It can detect a failure and readjust the cluster in less time than it takes
> you to realize a problem has occurred.
>
> What little you've shown of the script it appears you have to rebuild the
> cluster from scratch by defining a new primary, redefining the secondaries,
> then recovering them into the cluster. When a node is converted to standard
> mode, it loses all connections and knowledge of the secondaries. Recovering
> the secondaries takes time and is unnecessary when the -d makeprimary
> command
> is available..
>
> Carlton Doe
> dbaresrc@xmission.com
>
> Sent from my iPad -- typos and all
>
> > On Jul 6, 2016, at 8:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
> >
> > Hi,
> >
> > We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> > with HDR and a few RSS nodes. I read the docs and available literature on
> > HDR/RSS.
> >
> > When switching the HDR and Primary servers, is there any difference
> between
> > using the "onmode -d make primary <hdr_server>" command and using the
> > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> > standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
> >
> > I tested various scenarios and both seem to work well. Any difference or
> > is there a recommendation of when to use which set of commands?
> >
> > Thank You,
> >
> > --Dave
> >
> > --089e01183938fe68540536f7b1e2
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7b670743904bfc0536f81a67
Hi Art,
Thank you. Good to know the commands are basically equivalent in their
goal. I did notice 1 benefit to using the "onmode -d make primary" command
is that the HDR secondary stays up the whole time when being promoted to
primary and it doesn't require a restart.
Thank You,
--Dave
On Wed, Jul 6, 2016 at 10:01 AM, Art Kagel <art.kagel@gmail.com> wrote:
> Either way. Using the hdrmkpri.sh and hdrmksec.sh scripts is the easier way
> to do it. If you want to use onmode manually, you either have to go through
> the steps that the scripts do (ie using onmode -d primary and onmode -d
> secondary with shutdowns and restarts etc) or you can use onmode -d make
> primary .. on the secondary which will shutdown the primary and make the
> secondary primary then restart the primary with -PHY (which prevents fast
> recovery) then run onmode -d primary on the original primary to make it
> secondary to the promoted secondary.
>
> Easier to:
>
> 1. shutdown the primary - onmode -ky
>
> 2. run "hdrmkpri.sh orig_primary" on the original secondary
>
> 3. run "hdrmksec.sh orig_secondary" on the original primary
>
> 4. oninit on the promoted new primary to start it
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on 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 Wed, Jul 6, 2016 at 9:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
>
> > Hi,
> >
> > We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> > with HDR and a few RSS nodes. I read the docs and available literature on
> > HDR/RSS.
> >
> > When switching the HDR and Primary servers, is there any difference
> between
> > using the "onmode -d make primary <hdr_server>" command and using the
> > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> > standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
> >
> > I tested various scenarios and both seem to work well. Any difference or
> > is there a recommendation of when to use which set of commands?
> >
> > Thank You,
> >
> > --Dave
> >
> > --089e01183938fe68540536f7b1e2
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11444958cb3f0e0536f801fe
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11442b4694439e0536f8331e
Hello.
I would also use the steps suggested by Art Kagel, in case of manual failover.
Please be aware that 11.70.xC8 (your next release) has several APARs related
to high availability features, so I would also recommend you to check them
first, possibly avoiding any cluster malfunctioning, before you may need it.
It is always a good practice to check the documented APARs related to any new
feature you are planning to use.
Hope this helps.
Best regards.
Atenciosamente,
Alexandre Marini
[http://mcsoftware.com.br/mc_conteudo/assinaturas/logoassinatura.png]
[http://mcsoftware.com.br/mc_conteudo/assinaturas/arquiteturalogo.png]
________________________________
De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de Informix DBA
<in4mixdba@gmail.com>
Enviado: quarta-feira, 6 de julho de 2016 11:08:34
Para: ids@iiug.org
Assunto: Re: Switching HDR / Primary [37371]
Hi Carlton,
Thank you. The hdrmkpri.sh script is in the ${INFORMIXDIR}/bin script and
is an IBM script included with the engine referenced in the docs here
http://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/i
ds_admin_0949.htm.
I will take a look at the connection manager, though due to the nature of
the environment and app servers, we don't want any auto switchovers to
occur at this point.
Thank You,
--Dave
On Wed, Jul 6, 2016 at 9:55 AM, Carlton Doe <dbaresrc@xmission.com> wrote:
> I can't say I'm familiar with the script you mention but based on what you
> wrote, here's what I can tell you. First I would strongly encourage use of
> the
> connection manager. It will handle client connections and failover for you.
>
> Second, the onmode -d makeprimary does two important things: promote a new
> primary and reattatches all the secondaries at once. *Typically*, this is
> only
> executed in a maintenance period when you need to work on the server. For
> real
> life production settings, you want the connection manager handling
> failover.
> It can detect a failure and readjust the cluster in less time than it takes
> you to realize a problem has occurred.
>
> What little you've shown of the script it appears you have to rebuild the
> cluster from scratch by defining a new primary, redefining the secondaries,
> then recovering them into the cluster. When a node is converted to standard
> mode, it loses all connections and knowledge of the secondaries. Recovering
> the secondaries takes time and is unnecessary when the -d makeprimary
> command
> is available..
>
> Carlton Doe
> dbaresrc@xmission.com
>
> Sent from my iPad -- typos and all
>
> > On Jul 6, 2016, at 8:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
> >
> > Hi,
> >
> > We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> > with HDR and a few RSS nodes. I read the docs and available literature on
> > HDR/RSS.
> >
> > When switching the HDR and Primary servers, is there any difference
> between
> > using the "onmode -d make primary <hdr_server>" command and using the
> > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> > standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
> >
> > I tested various scenarios and both seem to work well. Any difference or
> > is there a recommendation of when to use which set of commands?
> >
> > Thank You,
> >
> > --Dave
> >
> > --089e01183938fe68540536f7b1e2
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7b670743904bfc0536f81a67
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi Alex,
Great idea on checking the APARs I will certainly take a look. That is a
great tip.
Thank You,
--Dave
On Wed, Jul 6, 2016 at 10:16 AM, Alexandre Marini <
alexandre@mcsoftware.com.br> wrote:
> Hello.
>
> I would also use the steps suggested by Art Kagel, in case of manual
> failover.
>
> Please be aware that 11.70.xC8 (your next release) has several APARs
> related
> to high availability features, so I would also recommend you to check them
> first, possibly avoiding any cluster malfunctioning, before you may need
> it.
>
> It is always a good practice to check the documented APARs related to any
> new
> feature you are planning to use.
>
> Hope this helps.
>
> Best regards.
>
> Atenciosamente,
> Alexandre Marini
>
> [http://mcsoftware.com.br/mc_conteudo/assinaturas/logoassinatura.png]
>
> [http://mcsoftware.com.br/mc_conteudo/assinaturas/arquiteturalogo.png]
> ________________________________
> De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de Informix DBA
> <in4mixdba@gmail.com>
> Enviado: quarta-feira, 6 de julho de 2016 11:08:34
> Para: ids@iiug.org
> Assunto: Re: Switching HDR / Primary [37371]
>
> Hi Carlton,
>
> Thank you. The hdrmkpri.sh script is in the ${INFORMIXDIR}/bin script and
> is an IBM script included with the engine referenced in the docs here
>
>
>
>
http://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.admin.doc/i
ds_admin_0949.htm
> .
>
> I will take a look at the connection manager, though due to the nature of
> the environment and app servers, we don't want any auto switchovers to
> occur at this point.
>
> Thank You,
>
> --Dave
>
> On Wed, Jul 6, 2016 at 9:55 AM, Carlton Doe <dbaresrc@xmission.com> wrote:
>
> > I can't say I'm familiar with the script you mention but based on what
> you
> > wrote, here's what I can tell you. First I would strongly encourage use
> of
> > the
> > connection manager. It will handle client connections and failover for
> you.
> >
> > Second, the onmode -d makeprimary does two important things: promote a
> new
> > primary and reattatches all the secondaries at once. *Typically*, this is
> > only
> > executed in a maintenance period when you need to work on the server. For
> > real
> > life production settings, you want the connection manager handling
> > failover.
> > It can detect a failure and readjust the cluster in less time than it
> takes
> > you to realize a problem has occurred.
> >
> > What little you've shown of the script it appears you have to rebuild the
> > cluster from scratch by defining a new primary, redefining the
> secondaries,
> > then recovering them into the cluster. When a node is converted to
> standard
> > mode, it loses all connections and knowledge of the secondaries.
> Recovering
> > the secondaries takes time and is unnecessary when the -d makeprimary
> > command
> > is available..
> >
> > Carlton Doe
> > dbaresrc@xmission.com
> >
> > Sent from my iPad -- typos and all
> >
> > > On Jul 6, 2016, at 8:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
> > >
> > > Hi,
> > >
> > > We are running Informix 11.70.FC7 on Solaris. We are setting up 1
> primary
> > > with HDR and a few RSS nodes. I read the docs and available literature
> on
> > > HDR/RSS.
> > >
> > > When switching the HDR and Primary servers, is there any difference
> > between
> > > using the "onmode -d make primary <hdr_server>" command and using the
> > > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode
> -d
> > > standard" , "onmode -d primary ${paired_server}" and then "onmode
> -ky").
> > >
> > > I tested various scenarios and both seem to work well. Any difference
> or
> > > is there a recommendation of when to use which set of commands?
> > >
> > > Thank You,
> > >
> > > --Dave
> > >
> > > --089e01183938fe68540536f7b1e2
> > >
> > >
> > >
> >
> >
>
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> >
> >
> >
> >
>
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --047d7b670743904bfc0536f81a67
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01183938043bcd0536f8b9ce
I would urge using onmode -d make primary... It does a lot of internal work
that the scripts don't do and thus minimizes the risk of any screw-up. The
connection manager internally uses make primary and we put in a lot of
coordination that the scripts can't do. If you want to write your own scripts
to manage a failover with your app servers, I would still use make primary.
Madison Pruet
Retired and Loving it
On Wednesday, July 6, 2016 7:56 AM, Carlton Doe <dbaresrc@xmission.com> wrote:
I can't say I'm familiar with the script you mention but based on what you
wrote, here's what I can tell you. First I would strongly encourage use of the
connection manager. It will handle client connections and failover for you.
Second, the onmode -d makeprimary does two important things: promote a new
primary and reattatches all the secondaries at once. *Typically*, this is only
executed in a maintenance period when you need to work on the server. For real
life production settings, you want the connection manager handling failover.
It can detect a failure and readjust the cluster in less time than it takes
you to realize a problem has occurred.
What little you've shown of the script it appears you have to rebuild the
cluster from scratch by defining a new primary, redefining the secondaries,
then recovering them into the cluster. When a node is converted to standard
mode, it loses all connections and knowledge of the secondaries. Recovering
the secondaries takes time and is unnecessary when the -d makeprimary command
is available..
Carlton Doe
dbaresrc@xmission.com
Sent from my iPad -- typos and all
> On Jul 6, 2016, at 8:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
>
> Hi,
>
> We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> with HDR and a few RSS nodes. I read the docs and available literature on
> HDR/RSS.
>
> When switching the HDR and Primary servers, is there any difference between
> using the "onmode -d make primary <hdr_server>" command and using the
> hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
>
> I tested various scenarios and both seem to work well. Any difference or
> is there a recommendation of when to use which set of commands?
>
> Thank You,
>
> --Dave
>
> --089e01183938fe68540536f7b1e2
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi,
Is there a way after the switchover after step 2 below, to split the
replication and bring up the orig_Primary in standalone mode? I tried a
few commands (in a test env) "oninit", "oninit -PHY and onmode -d standard"
though the orig_Primary is still in "Fast Recovery".
The intended result would be to have all RSS servers synced to the new
Primary and have the orig_primary be a standalone server before it syncs
with the new_Primary?
Thank You,
--Dave
On Wed, Jul 6, 2016 at 10:01 AM, Art Kagel <art.kagel@gmail.com> wrote:
> Either way. Using the hdrmkpri.sh and hdrmksec.sh scripts is the easier way
> to do it. If you want to use onmode manually, you either have to go through
> the steps that the scripts do (ie using onmode -d primary and onmode -d
> secondary with shutdowns and restarts etc) or you can use onmode -d make
> primary .. on the secondary which will shutdown the primary and make the
> secondary primary then restart the primary with -PHY (which prevents fast
> recovery) then run onmode -d primary on the original primary to make it
> secondary to the promoted secondary.
>
> Easier to:
>
> 1. shutdown the primary - onmode -ky
>
> 2. run "hdrmkpri.sh orig_primary" on the original secondary
>
> 3. run "hdrmksec.sh orig_secondary" on the original primary
>
> 4. oninit on the promoted new primary to start it
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on 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 Wed, Jul 6, 2016 at 9:39 AM, Informix DBA <in4mixdba@gmail.com> wrote:
>
> > Hi,
> >
> > We are running Informix 11.70.FC7 on Solaris. We are setting up 1 primary
> > with HDR and a few RSS nodes. I read the docs and available literature on
> > HDR/RSS.
> >
> > When switching the HDR and Primary servers, is there any difference
> between
> > using the "onmode -d make primary <hdr_server>" command and using the
> > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode -d
> > standard" , "onmode -d primary ${paired_server}" and then "onmode -ky").
> >
> > I tested various scenarios and both seem to work well. Any difference or
> > is there a recommendation of when to use which set of commands?
> >
> > Thank You,
> >
> > --Dave
> >
> > --089e01183938fe68540536f7b1e2
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11444958cb3f0e0536f801fe
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--047d7b86e4be9b0a540538765874
You can probably do this, but I'd have to play with it a bit to be sure.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on 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 Mon, Jul 25, 2016 at 10:10 AM, Informix DBA <in4mixdba@gmail.com> wrote:
> Hi,
>
> Is there a way after the switchover after step 2 below, to split the
> replication and bring up the orig_Primary in standalone mode? I tried a
> few commands (in a test env) "oninit", "oninit -PHY and onmode -d standard"
> though the orig_Primary is still in "Fast Recovery".
>
> The intended result would be to have all RSS servers synced to the new
> Primary and have the orig_primary be a standalone server before it syncs
> with the new_Primary?
>
> Thank You,
>
> --Dave
>
> On Wed, Jul 6, 2016 at 10:01 AM, Art Kagel <art.kagel@gmail.com> wrote:
>
> > Either way. Using the hdrmkpri.sh and hdrmksec.sh scripts is the easier
> way
> > to do it. If you want to use onmode manually, you either have to go
> through
> > the steps that the scripts do (ie using onmode -d primary and onmode -d
> > secondary with shutdowns and restarts etc) or you can use onmode -d make
> > primary .. on the secondary which will shutdown the primary and make the
> > secondary primary then restart the primary with -PHY (which prevents fast
> > recovery) then run onmode -d primary on the original primary to make it
> > secondary to the promoted secondary.
> >
> > Easier to:
> >
> > 1. shutdown the primary - onmode -ky
> >
> > 2. run "hdrmkpri.sh orig_primary" on the original secondary
> >
> > 3. run "hdrmksec.sh orig_secondary" on the original primary
> >
> > 4. oninit on the promoted new primary to start it
> >
> > Art
> >
> > Art S. Kagel, President and Principal Consultant
> > ASK Database Management
> > www.askdbmgt.com
> >
> > Blog: http://informix-myview.blogspot.com/
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> > and do not reflect on 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 Wed, Jul 6, 2016 at 9:39 AM, Informix DBA <in4mixdba@gmail.com>
> wrote:
> >
> > > Hi,
> > >
> > > We are running Informix 11.70.FC7 on Solaris. We are setting up 1
> primary
> > > with HDR and a few RSS nodes. I read the docs and available literature
> on
> > > HDR/RSS.
> > >
> > > When switching the HDR and Primary servers, is there any difference
> > between
> > > using the "onmode -d make primary <hdr_server>" command and using the
> > > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes "onmode
> -d
> > > standard" , "onmode -d primary ${paired_server}" and then "onmode
> -ky").
> > >
> > > I tested various scenarios and both seem to work well. Any difference
> or
> > > is there a recommendation of when to use which set of commands?
> > >
> > > Thank You,
> > >
> > > --Dave
> > >
> > > --089e01183938fe68540536f7b1e2
> > >
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11444958cb3f0e0536f801fe
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --047d7b86e4be9b0a540538765874
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a113f8aae8eac5f0538768809
Thank you Art. I found the "oninit -S" command which seems to accomplish
what we are looking to do. From the documentation, "oninit -S" "Starts
database server in quiescent mode as a standard server with
high-availability data replication disabled."
I tested it and seems to work good.
Thank You,
--Dave
On Mon, Jul 25, 2016 at 10:24 AM, Art Kagel <art.kagel@gmail.com> wrote:
> You can probably do this, but I'd have to play with it a bit to be sure.
>
> Art
>
> Art S. Kagel, President and Principal Consultant
> ASK Database Management
> www.askdbmgt.com
>
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions
> and do not reflect on 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 Mon, Jul 25, 2016 at 10:10 AM, Informix DBA <in4mixdba@gmail.com>
> wrote:
>
> > Hi,
> >
> > Is there a way after the switchover after step 2 below, to split the
> > replication and bring up the orig_Primary in standalone mode? I tried a
> > few commands (in a test env) "oninit", "oninit -PHY and onmode -d
> standard"
> > though the orig_Primary is still in "Fast Recovery".
> >
> > The intended result would be to have all RSS servers synced to the new
> > Primary and have the orig_primary be a standalone server before it syncs
> > with the new_Primary?
> >
> > Thank You,
> >
> > --Dave
> >
> > On Wed, Jul 6, 2016 at 10:01 AM, Art Kagel <art.kagel@gmail.com> wrote:
> >
> > > Either way. Using the hdrmkpri.sh and hdrmksec.sh scripts is the easier
> > way
> > > to do it. If you want to use onmode manually, you either have to go
> > through
> > > the steps that the scripts do (ie using onmode -d primary and onmode -d
> > > secondary with shutdowns and restarts etc) or you can use onmode -d
> make
> > > primary .. on the secondary which will shutdown the primary and make
> the
> > > secondary primary then restart the primary with -PHY (which prevents
> fast
> > > recovery) then run onmode -d primary on the original primary to make it
> > > secondary to the promoted secondary.
> > >
> > > Easier to:
> > >
> > > 1. shutdown the primary - onmode -ky
> > >
> > > 2. run "hdrmkpri.sh orig_primary" on the original secondary
> > >
> > > 3. run "hdrmksec.sh orig_secondary" on the original primary
> > >
> > > 4. oninit on the promoted new primary to start it
> > >
> > > Art
> > >
> > > Art S. Kagel, President and Principal Consultant
> > > ASK Database Management
> > > www.askdbmgt.com
> > >
> > > Blog: http://informix-myview.blogspot.com/
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> opinions
> > > and do not reflect on 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 Wed, Jul 6, 2016 at 9:39 AM, Informix DBA <in4mixdba@gmail.com>
> > wrote:
> > >
> > > > Hi,
> > > >
> > > > We are running Informix 11.70.FC7 on Solaris. We are setting up 1
> > primary
> > > > with HDR and a few RSS nodes. I read the docs and available
> literature
> > on
> > > > HDR/RSS.
> > > >
> > > > When switching the HDR and Primary servers, is there any difference
> > > between
> > > > using the "onmode -d make primary <hdr_server>" command and using the
> > > > hdrmkpri.sh script (yes I know the hdrmkpri.sh script executes
> "onmode
> > -d
> > > > standard" , "onmode -d primary ${paired_server}" and then "onmode
> > -ky").
> > > >
> > > > I tested various scenarios and both seem to work well. Any difference
> > or
> > > > is there a recommendation of when to use which set of commands?
> > > >
> > > > Thank You,
> > > >
> > > > --Dave
> > > >
> > > > --089e01183938fe68540536f7b1e2
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --001a11444958cb3f0e0536f801fe
> > >
> > >
> > >
> > >
> >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --047d7b86e4be9b0a540538765874
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a113f8aae8eac5f0538768809
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0122e9beee760005388aabb5