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

gareth.2.edwards at bt.com gareth.2.edwards at bt.com
Fri Nov 23 05:48:49 EST 2007 

Hi Joan,

Thanks, that's good to know. TBH, I think if any, this will be the
approach taken. Just waiting on some prices of replication software to
compare.

Then again, like normal, the client at the last minute will pull the
plug and decide against it. Anyway, if they go for it, it seems there's
several brains on this list I can pester for help.  :o)   


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 Berry, J
(Joan)
Sent: Thursday, November 22, 2007 5:26 PM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator

Hi Gareth,

This is what we do now and works far quicker and without the maintenance
overhead of replicator 2.5.  We transfer every 15 mins to the standby
machine and we also have a user test system which we transfer to once a
week. It all works pretty well.

Joan :-)

-----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 2:08 PM
To: International OpenROAD Users
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator

Yes, it is a fairly straightforward process.
You set up the hot server and restore a checkpoint. 
The setup is the same no matter how many tables.
This takes the most time initially.

Set up a script to regularly check and copy over journal files and run
rollforwarddb (journals only).
The sync time is as long as it takes to copy across journals.
You should probably get a DBA / Sysadmin to assist however there is a
good thread on cdi around 13 Oct 2007. Search for "log shipping".

My tool I use for syncronising a handful of tables is probably not
suitable. It requires analysis of each table to find a primary unique
key, then configure a trigger to record all changes in a central queue
which is then processed and cleared once every 10 minutes. 

If you cant find a capable DBA / consultant to assist, feel free to
contact me offline.

cheers
Paul



-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
gareth.2.edwards at bt.com
Sent: Thursday, 22 November 2007 11:39 PM
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator

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 

________________________________________________________________
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 

________________________________________________________________
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 

________________________________________________________________
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

More information about the Openroad-users mailing list