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

[gareth.2.edwards at bt.com]

Hi Paul,

The current requirements are for an exact mirror. Price dependant, I'm
sure they would settle for "minutes".

Tell me about log shipping, is that just transferring
journals/transaction log and applying to the standby machine?

If so, (hands-up, I'm no DBA) how long would it take to apply (let's say
150 tables)?

(Will follow C.D.I threads, thanks)


Cheers,
Gareth Edwards

BT Global Services 
tel: +44 (0)131 345 4671 
email: gareth.2.edwards at bt.com

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Paul White
Sent: Thursday, November 22, 2007 1:29 PM
To: International OpenROAD Users
Cc: info-ingres at kettleriverconsulting.com
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator

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


________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

To unsubscribe click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe