Re: Linux & Oracle High Availability

I believe there is now some clustering capability as an add on in Linux. However, OPS as you say has not been released on this yet. So your options are three fold:

1. Check into the clustering software. Most clustering software allows you to script a failover from one node to another. This gives slightly lower availability than OPS but it may be sufficient.
2. Standby database. I don't really understand your comment about that not being nice. Lots of people use it, and with the new functionality in 8i it really is quite suitable for a high availability scenario.
3. Multi-master replication. The major issue here is (as it always has been) the business decisions to handle conflict. Technically, it works fine.

Which of these three suits you is going to be site and even application dependent, and you haven't provided enough information for us to advise on this. One comment I would make though, is why do you want a highly available development environment, unless it's to test a highly available Production environment?

HTH. Pete

Gerald Anleitner wrote:

> Hi!
> We're working on Linux platforms and are searching for ways to add some High
> Availability feeling to our Linux/Oracle development platform.
> As it seems to me, the Paralell Server Option of Oracle is not really available
> for Linux as there is no OS-bound cluster software available resp. is not
> working together with Oracle's DB.
>
> So what else is possible? There is this Standby Database, but that's not really
> nice, I think!?
>
> Thus it seems we're stuck with a Multimaster Replication. We will have some kind
> of middleware that distributes incoming queries to the several servers running
> the Multimaster Replication. What do you think? Is this a good idea? What else
> could we do?
>
> Would be great to hear about your ideas!
>
> Bye for now,
> Gerald

Received on Tue Dec 14 1999 - 10:28:52 CST