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

gareth.2.edwards at bt.com gareth.2.edwards at bt.com
Fri Nov 23 03:05:37 EST 2007 

A minute. I'm liking that! 


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

I guess it will depend on the speed of your server and how many updates
have occurred since the last sync.
I've found the journal rollforward to be pretty fast. 

On one of my servers a 10Gb database the checkpoint (with compression)
takes around 10 minutes. The full restore took around the same. A days
worth of transactions can be as much as 100Mb. These took a minute or so
to update.

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: Friday, 23 November 2007 12:53 AM
To: openroad-users at peerlessit.com
Subject: Re: [Openroad-users] Let's talk replication & ingres replicator

OK, seems fairly straightforward. 

The rollforwarddb, (journals only). How long does this take generally? 

If it helps there's 150 tables, some have 500,000 rows and a copydb of
the whole DB, with nologging runs in 2hrs.

If this option is chosen (could well be as it will be the cheapest), I
will definitely drop you an email, thanks for your help.


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 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 

________________________________________________________________
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