HDR Replication Requirements
Hi I'm am still evaluation replication of my IDS 9.4 database. The reason we want to do replication is that we want to read data from the secondary server for reporting purposes (to alleviate some of the load from the primary server) I was thinking of doing ER replication but now I have found a server with the same spec as the primary server. So I can look at HDR replication as well (as apparently its easier) In HDR Both servers need the same OS and version of IDS. Both servers need to have (or be close) to the same spec. The chunks need to be the same on both servers. The log space needs to be same on both servers. This I can satisfy. The question I have is if the secondary server is in recovery can I read from it for reporting purposes ? thanks
You need to perform a physical restore on secondary server from primary server's level 0 backup. After physical restore is complete and after primary server sends logs to the secondary server the secondary server status will become a read - Only server. This read only server can be used as a report server. Fairly straightforward and much quicker to implement. Starting with 11.5x version of Informix HDR, you now have ability to define a updatable secondary server (read and writes are allowed on secondary). More of a bi-directional update in HDR environment. --- On Sun, 11/8/09, BRETT SIMPSON <brett.simpson@actrol.com.au> wrote: From: BRETT SIMPSON <brett.simpson@actrol.com.au> Subject: HDR Replication Requirements [17993] To: ids@iiug.org Date: Sunday, November 8, 2009, 9:52 PM Hi I'm am still evaluation replication of my IDS 9.4 database. The reason we want to do replication is that we want to read data from the secondary server for reporting purposes (to alleviate some of the load from the primary server) I was thinking of doing ER replication but now I have found a server with the same spec as the primary server. So I can look at HDR replication as well (as apparently its easier) In HDR Both servers need the same OS and version of IDS. Both servers need to have (or be close) to the same spec. The chunks need to be the same on both servers. The log space needs to be same on both servers. This I can satisfy. The question I have is if the secondary server is in recovery can I read from it for reporting purposes ? thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
ids-bounces@iiug.org wrote on 11/08/2009 09:52:49 PM: > "BRETT SIMPSON" <brett.simpson@actrol.com.au> > Sent by: ids-bounces@iiug.org > > 11/08/2009 09:52 PM > > Please respond to > ids@iiug.org > > To > > ids@iiug.org > > cc > > Subject > > HDR Replication Requirements [17993] > > Hi > > I'm am still evaluation replication of my IDS 9.4 database. > > The reason we want to do replication is that we want to read data from the > secondary server for reporting purposes (to alleviate some of the load from > the primary server) > > I was thinking of doing ER replication but now I have found a server with the > same spec as the primary server. > > So I can look at HDR replication as well (as apparently its easier) > > In HDR > > Both servers need the same OS and version of IDS. > > Both servers need to have (or be close) to the same spec. > > The chunks need to be the same on both servers. > > The log space needs to be same on both servers. > > This I can satisfy. > > The question I have is if the secondary server is in recovery can I read from > it for reporting purposes ? > > thanks Yes, the HDR secondary server can be used for reading/reporting purposes. in recovery mode. It is worth reading the chapter on "High-Availability Data Replication" in the Administrator's Guide to understand how HDR works, what data is replicated, what is not, etc. Thanks. Davis. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >