can we have to hdr servers ?
A user with an existing HDR secondary asked whether a second HDR server could be added. Answer: no — only one HDR secondary is allowed, but you can have multiple RSS (remote standalone) secondaries, available since 11.10. Setup is similar to HDR: restore, then 'onmode -d RSS <primary>' on the secondary and 'onmode -d add RSS <secondary>' on the primary (RSS must be uppercase), or use ifxclone. Licensing is only needed if the secondary is actually accessed while the primary is online; standby-only use is free. Secondaries can be made updatable (UPDATEABLE_SECONDARY), with writes passed to the primary so servers stay in sync, but ontape/onbar archives can't run on a secondary — only external backups via onmode -c block/unblock. A final follow-up about required host/sqlhosts/onconfig setup went unanswered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi to all I have an hdr server with my production server. And i. ' want. To have a second. Is it possible and how to set it ? The same way. As the first one ? Thanks in advance
Strictly speaking the answer is "no". You can have ONE hdr server and
several RSS servers.
RSS or remote secondary servers act much like HDR secondaries, but they
were design to work in a more "detached" mode. And you can have more than
one of these.
They appeared in v11.10. So if you're using a version older than this it
won't work.
As to how to set them, you really should see some manual information,
webcasts, redbook etc.
Very briefly it's like setting up an HDR server, but the "onmode -d"
commands are a bit different (and you could use ifxclone)
As a side note, a question like this in 2014 mean a lot about our inability
to communicate.
We're talking about a technology introduced 7 years ago.
Regards.
On Fri, Jan 24, 2014 at 5:43 PM, SMITH JOHN <daylight@webmails.com> wrote:
> Hi to all
> I have an hdr server with my production server. And i. ' want. To have a
> second.
> Is it possible and how to set it ? The same way. As the first one ?
> Thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
--001a113395b615a1e104f0bb0a9c
Thanks a lot for your response
You can only have one HDR secondary, but you can have any number of RSS
secondaries that you want. The setup is similar to setting up an HDR
secondary: Restore, run onmode -d RSS <primary_name> on the secondary, run
onmode -d add RSS <secondary_name> on the primary (Note: the 'RSS' keywordis case sensitive it MUST be in upper case). Alternatively you can use
ifxclone to create the RSS secondary in a single step.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
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 Fri, Jan 24, 2014 at 12:43 PM, SMITH JOHN <daylight@webmails.com> wrote:
> Hi to all
> I have an hdr server with my production server. And i. ' want. To have a
> second.
> Is it possible and how to set it ? The same way. As the first one ?
> Thanks in advance
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e01183076e3e92304f0bb5299
I have the informix 1150 ultimate, should i pay a license for rss ?
On 11.50.xC7+ you just have to pay if you use it for queries.... If the purpose is just for standy no. Regards. On Fri, Jan 24, 2014 at 6:18 PM, SMITH JOHN <daylight@webmails.com> wrote: > I have the informix 1150 ultimate, should i pay a license for rss ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b673c86bb214604f0bb6f13
In fact i will use it for backuping the production. Is the rss read. Only. Likr hdr ?
If you do not access the data from a seccondary, whether it's an HDR, RSS, or SDS secondary, while the primary is online, then you do not need an additional license. Art Art S. Kagel, Principal Consultant ASK Database Management 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 Fri, Jan 24, 2014 at 1:18 PM, SMITH JOHN <daylight@webmails.com> wrote: > I have the informix 1150 ultimate, should i pay a license for rss ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113801a030a92704f0bb7f2a
RSS and HDR can both be either read-only or read-write now. But, as noted,
if you actually write to it (or even just read from it), you have to
license the server on the secondary. You cannot take an archive from a
secondary using ontape or onbar. You can only take an external back up by
pausing the server with onmode -c block, copy the chunk files to backup,
then release the server using onmode -c unblock.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com> wrote:
> In fact i will use it for backuping the production. Is the rss read. Only.
> Likr hdr ?
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11c3505cc61a0e04f0bb88ce
"backup" the data or backing up the workload? Sin 11.50 any type of secondary server (HDR, RSS or SDS - this share the disks with the primary - ) can be put in updatable mode. Nevertheless this mode does not allow you to use "standard" backup as this requires direct write over the data pages which not even SDS have. You can howerer use RSS to run backups of your servers using "external" tools that will get a snapshot of the pages. For that you need to "freeze" the RSS. I'd have to check in which version/fixpack we introduced this functionality. Regards. On Fri, Jan 24, 2014 at 6:25 PM, SMITH JOHN <daylight@webmails.com> wrote: > In fact i will use it for backuping the production. Is the rss read. Only. > Likr hdr ? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b673bda96c3a304f0bb8c95
So, when you say that the HDR secondary can be read-write now, do you mean
just the temporary table or do you mean actual data? If you update actual
data, doesn't that make the servers out of sync, or does it send the changes
back to the primary? It's starting to sound like ER.
Larry
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: can we have to hdr servers ? [32332]
> Date: Fri, 24 Jan 2014 13:29:16 -0500
>
> RSS and HDR can both be either read-only or read-write now. But, as noted,
> if you actually write to it (or even just read from it), you have to
> license the server on the secondary. You cannot take an archive from a
> secondary using ontape or onbar. You can only take an external back up by
> pausing the server with onmode -c block, copy the chunk files to backup,
> then release the server using onmode -c unblock.
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> 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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com> wrote:
>
> > In fact i will use it for backuping the production. Is the rss read. Only.
> > Likr hdr ?
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c3505cc61a0e04f0bb88ce
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
The rss server will be in stand by mode, it will be set in updatable mode and used only if the production server crashes.
I do mean updates initiated by sessions connected to a secondary server,
yes. The server stay in sync because the secondary actually passes the
request on to the primary which updates the rows locally on the primary
then the usual log shipping passes the updated pages to the secondaries.
When the secondary receives the commit logical log record it refreshes its
cached copy of any updated pages from disk and poof, all is in sync.
There is an ONCONFIG parameter, UPDATEABLE_SECONDARY, and a few others,
that control this feature which is disabled by default.
Art
Art S. Kagel, Principal Consultant
ASK Database Management
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 Fri, Jan 24, 2014 at 1:33 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote:
> So, when you say that the HDR secondary can be read-write now, do you mean
> just the temporary table or do you mean actual data? If you update actual
> data, doesn't that make the servers out of sync, or does it send the
> changes
> back to the primary? It's starting to sound like ER.
>
> Larry
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: can we have to hdr servers ? [32332]
> > Date: Fri, 24 Jan 2014 13:29:16 -0500
> >
> > RSS and HDR can both be either read-only or read-write now. But, as
> noted,
> > if you actually write to it (or even just read from it), you have to
> > license the server on the secondary. You cannot take an archive from a
> > secondary using ontape or onbar. You can only take an external back up by
> > pausing the server with onmode -c block, copy the chunk files to backup,
> > then release the server using onmode -c unblock.
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > 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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com>
> wrote:
> >
> > > In fact i will use it for backuping the production. Is the rss read.
> Only.
> > > Likr hdr ?
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c3505cc61a0e04f0bb88ce
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11345d4ef3081e04f0bbd1b3
Note that as a bonus if the primary crashes whichever secondary server
takes over as the new primary will complete the transaction so that
transactions initiated on a secondary are uninterruptable! (Transactions
initiated on the primary will be rolled back by the new primary when it
takes over.)
Art
Art S. Kagel, Principal Consultant
ASK Database Management
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 Fri, Jan 24, 2014 at 1:48 PM, Art Kagel <art.kagel@gmail.com> wrote:
> I do mean updates initiated by sessions connected to a secondary server,
> yes. The server stay in sync because the secondary actually passes the
> request on to the primary which updates the rows locally on the primary
> then the usual log shipping passes the updated pages to the secondaries.
> When the secondary receives the commit logical log record it refreshes its
> cached copy of any updated pages from disk and poof, all is in sync.
>
> There is an ONCONFIG parameter, UPDATEABLE_SECONDARY, and a few others,
> that control this feature which is disabled by default.
>
> Art
>
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> 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 Fri, Jan 24, 2014 at 1:33 PM, LARRY SORENSEN <lsorensen25@msn.com>wrote:
>
>> So, when you say that the HDR secondary can be read-write now, do you mean
>> just the temporary table or do you mean actual data? If you update actual
>> data, doesn't that make the servers out of sync, or does it send the
>> changes
>> back to the primary? It's starting to sound like ER.
>>
>> Larry
>>
>> > To: ids@iiug.org
>> > From: art.kagel@gmail.com
>> > Subject: Re: can we have to hdr servers ? [32332]
>> > Date: Fri, 24 Jan 2014 13:29:16 -0500
>> >
>> > RSS and HDR can both be either read-only or read-write now. But, as
>> noted,
>> > if you actually write to it (or even just read from it), you have to
>> > license the server on the secondary. You cannot take an archive from a
>> > secondary using ontape or onbar. You can only take an external back up
>> by
>> > pausing the server with onmode -c block, copy the chunk files to backup,
>> > then release the server using onmode -c unblock.
>> >
>> > Art
>> >
>> > Art S. Kagel, Principal Consultant
>> > ASK Database Management
>> >
>> > 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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com>
>> wrote:
>> >
>> > > In fact i will use it for backuping the production. Is the rss read.
>> Only.
>> > > Likr hdr ?
>> > >
>> > >
>> > >
>> > >
>> >
>>
>>
*******************************************************************************
>> > > Forum Note: Use "Reply" to post a response in the discussion forum.
>> > >
>> > >
>> >
>> > --001a11c3505cc61a0e04f0bb88ce
>> >
>> >
>> >
>>
>>
*******************************************************************************
>> > Forum Note: Use "Reply" to post a response in the discussion forum.
>> >
>>
>>
>>
>>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>
--089e0122797aad25cb04f0bbd843
Thanks a lot gentlemen.
So, when you say that the HDR secondary can be read-write now, do you mean
just the temporary table or do you mean actual data? If you update actual
data, doesn't that make the servers out of sync, or does it send the changes
back to the primary? It's starting to sound like ER.
Larry
> To: ids@iiug.org
> From: art.kagel@gmail.com
> Subject: Re: can we have to hdr servers ? [32332]
> Date: Fri, 24 Jan 2014 13:29:16 -0500
>
> RSS and HDR can both be either read-only or read-write now. But, as noted,
> if you actually write to it (or even just read from it), you have to
> license the server on the secondary. You cannot take an archive from a
> secondary using ontape or onbar. You can only take an external back up by
> pausing the server with onmode -c block, copy the chunk files to backup,
> then release the server using onmode -c unblock.
>
> Art
>
> Art S. Kagel, Principal Consultant
> ASK Database Management
>
> 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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com> wrote:
>
> > In fact i will use it for backuping the production. Is the rss read. Only.
> > Likr hdr ?
> >
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a11c3505cc61a0e04f0bb88ce
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Oops. Got sent twice for some reason.
> To: ids@iiug.org
> From: lsorensen25@msn.com
> Subject: RE: can we have to hdr servers ? [32339]
> Date: Fri, 24 Jan 2014 14:21:38 -0500
>
> So, when you say that the HDR secondary can be read-write now, do you mean
> just the temporary table or do you mean actual data? If you update actual
> data, doesn't that make the servers out of sync, or does it send the changes
> back to the primary? It's starting to sound like ER.
>
> Larry
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: can we have to hdr servers ? [32332]
> > Date: Fri, 24 Jan 2014 13:29:16 -0500
> >
> > RSS and HDR can both be either read-only or read-write now. But, as noted,
> > if you actually write to it (or even just read from it), you have to
> > license the server on the secondary. You cannot take an archive from a
> > secondary using ontape or onbar. You can only take an external back up by
> > pausing the server with onmode -c block, copy the chunk files to backup,
> > then release the server using onmode -c unblock.
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > 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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com> wrote:
> >
> > > In fact i will use it for backuping the production. Is the rss read.
Only.
> > > Likr hdr ?
> > >
> > >
> > >
> > >
> >
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c3505cc61a0e04f0bb88ce
> >
> >
> >
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
The update requests are procesed by the primary in a transparent way. So
no problem with the sync. You may face some new application errors (the
changes will fail) if you try to change stalled data.
Regards.
Em 24/01/2014 18:34, "LARRY SORENSEN" <lsorensen25@msn.com> escreveu:
> So, when you say that the HDR secondary can be read-write now, do you mean
> just the temporary table or do you mean actual data? If you update actual
> data, doesn't that make the servers out of sync, or does it send the
> changes
> back to the primary? It's starting to sound like ER.
>
> Larry
>
> > To: ids@iiug.org
> > From: art.kagel@gmail.com
> > Subject: Re: can we have to hdr servers ? [32332]
> > Date: Fri, 24 Jan 2014 13:29:16 -0500
> >
> > RSS and HDR can both be either read-only or read-write now. But, as
> noted,
> > if you actually write to it (or even just read from it), you have to
> > license the server on the secondary. You cannot take an archive from a
> > secondary using ontape or onbar. You can only take an external back up by
> > pausing the server with onmode -c block, copy the chunk files to backup,
> > then release the server using onmode -c unblock.
> >
> > Art
> >
> > Art S. Kagel, Principal Consultant
> > ASK Database Management
> >
> > 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 Fri, Jan 24, 2014 at 1:25 PM, SMITH JOHN <daylight@webmails.com>
> wrote:
> >
> > > In fact i will use it for backuping the production. Is the rss read.
> Only.
> > > Likr hdr ?
> > >
> > >
> > >
> > >
> >
>
>
*******************************************************************************
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --001a11c3505cc61a0e04f0bb88ce
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--089e0115f044baf13c04f0bd30f6
hello i think that we need to do some things for the communication isn't it ? .rhosts /etc/hosts INFORMIXSQLHOSTS ONCONFIG