[Openroad-users] Let's talk replication & ingres replicator

[Paul White]

Hi Gareth

How hot does the standby machine need to be? 
Can it lag behind the primary server by a couple of minutes?
If so, log shipping may be the answer.
 
Or perhaps if you just need to replicate a few tables you can kick off a
syncronisation process every few minutes to transfer newly updated data.
I do this successfully over a 256K wan link.

I think you will get a better response over at comp.databases.ingres. 
I've forwarded this thread minus the actual email links. Check out the
responses here: 
http://groups.google.com.au/group/comp.databases.ingres

You might like to subscribe to the very useful info-ingres list server
here:
http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

Cheers

Paul

________________________________

From: Gareth Edwards
Sent: Thursday, 22 November 2007 11:08 PM
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator


Was that specifically Ingres Replicator?
 
Because if it is and it's cheap enough, maybe that will be dragged
kicking and screaming onto a newer version of Ingres.
 

Cheers, 
Gareth Edwards 

BT Global Services 
tel: xxx 

 

________________________________

From: Joan Berry
Sent: Thursday, November 22, 2007 12:07 PM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator


Hi Gareth,
 
We ran Replication with IngresII 2.6 02/06 and OpenRoad 4.1, very
sucessfully for a couple of years, however we abandoned this solution in
favour of RAID and the fact that the overhead maintenance attached to
collisions proved to high.
 
Joan :-)
 

________________________________

From: Gareth Edwards
Sent: Thursday, November 22, 2007 11:53 AM
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Let's talk replication & ingres replicator


Hi All,
 
We have an old system, which needs to be replicated, so if the live
system goes down, the standby system can take over. The transactions
then done on the standby system will need to be applied to the live
machine when it returns.
 
I remember Ingres Replicator being a solution.
 
The main problem which i think will be a stumbling block, would be it's
old technology.
 
Ingres 6.4 DB
OpenROAD 3.5
Solaris 8
 
Any thoughts/comments/suggestions on how this could be achieved, or if
it can.
 

Cheers, 
Gareth Edwards 

BT Global Services 
tel: xxx