Re: Advanced Queuing vs. Replication?

Alex

If I'm reading your architecture correctly, you won't be able to use replication for what you want to do. Are you attempting to replicate data from master 1 to masters 2 and 3, and then from master 2 to masters 4 and 5, and master 3 to masters 5 and 6. If so, I don't think cascading masters are supported, or even cascading snapshots for that matter. You would need for all the databases to point to one another in a true multi-master configuration, and that may not achieve what you want to do.

Queuing is a possibility. You would need to enqueue from master 1, dequeue from masters 2 and 3, and have triggers fire on masters 2 and 3 to enqueue to the next level down. You say 8i is not a possibility. One of the things that was improved a lot in 8i was the performance of the queuing, so you'd need to volume test the configuration to ensure you get the throughput you want.

HTH. Pete

AleX wrote:

> Hello all,
>
> I was wondering if anyone could share their experiences with Advanced
> Queuing in 8.0.5
> I won't be able to use 8i, so the whole thing will happen in 8.0.5
> Basically, what I'm looking to do is to propogate the contents of quite
> a few tables in my schema to four or five other databases. The push is
> going to be tree-like. i.e. from one fronting database to another 2 and
> then to another four.
>
> Now we are faced with the choice of either using Adv. Queuing, or using
> replication. If we use Adv. Queuing, what are the advantages of this
> approach? Can we use a built-in functionality in OEM? If we choose to go
> with replication, does this sound like a feasible idea given that we
> will have like 30 or 40 master tables?
>
> Please either respond in person, or simply post a reply here. All help
> is appreciated.
>
> --
> Alex Shterenberg
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards

Pete

Received on Wed Jul 28 1999 - 14:52:19 CDT