Failover setup

We have production databases, informix 11.10.FC2 on SLES 10, currently w/o failover servers. We are deciding upon the type of failover setup (HDR/ER) to be set for these servers. Some databases are in "no logging" mode (due to business requirements) while some are using blobspaces. what are the factors to decide upon the type of failover? Does HDR work for no logging dbs and blobspaces?

Hello. Maybe this table could help you, ER feature is not intended to solve failover questions, really. http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.admin.doc/id s_admin_1381.htm Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional Database Administrator > To: ids@iiug.org > From: ksushants@gmail.com > Subject: Failover setup [26685] > Date: Mon, 9 Apr 2012 02:37:51 -0400 > > We have production databases, informix 11.10.FC2 on SLES 10, currently w/o > failover servers. We are deciding upon the type of failover setup (HDR/ER) to > be set for these servers. Some databases are in "no logging" mode (due to > business requirements) while some are using blobspaces. > what are the factors to decide upon the type of failover? Does HDR work for no > logging dbs and blobspaces? > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

You cannot use any kind of replication for a database that is unlogged except archive and restore. For those databases, without logical logs, your copy will always be behind the production instance. Logged databases with blobspace blobs (TEXT & BYTE type columns created IN <blobspace>) will not replicate using HDR or RSS and cannot participate in a writable SDS secondary. You can only replicate blobspace blobs using ER and only if the database has logging turned on. With the sole exception of data warehouse instances, all databases should be logged and so support transactions. Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 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 Mon, Apr 9, 2012 at 2:37 AM, SUSHANT KODE <ksushants@gmail.com> wrote: > We have production databases, informix 11.10.FC2 on SLES 10, currently w/o > failover servers. We are deciding upon the type of failover setup (HDR/ER) > to > be set for these servers. Some databases are in "no logging" mode (due to > business requirements) while some are using blobspaces. > what are the factors to decide upon the type of failover? Does HDR work > for no > logging dbs and blobspaces? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8f3ba959464e6e04bd3e9d76

If your database is not using logging, then the best you can do is to t= ake advantage of disk replication to an alternate location. You will need = to ensure that the disk replication is done using ordered IO across all of= the disks which make up your database. --- that is, the disk replication = must be done in the same order as the writes on the main system. Also, the = disk replication must be over all of the disks comprising the primary system= and the order must be maintained across those set of disks. You can have informix installed at the target site, but it can not be running. You = can only bring the instance up at the secondary site if the primary is down= . = = From: "SUSHANT KODE" <ksushants@gmail.com> = = = = To: ids@iiug.org = = = = Date: 04/09/2012 01:38 AM = = = = Subject: Failover setup [26685] = = = = Sent by: ids-bounces@iiug.org = = = = We have production databases, informix 11.10.FC2 on SLES 10, currently = w/o failover servers. We are deciding upon the type of failover setup (HDR/= ER) to be set for these servers. Some databases are in "no logging" mode (due = to business requirements) while some are using blobspaces. what are the factors to decide upon the type of failover? Does HDR work= for no logging dbs and blobspaces? ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =