|
On Fri, Apr 12, 2002 at 08:56:23AM +0100, Malcolm Cowe mentioned:
> What if the real servers were also configured to be part of an HA
> cluster like SGI Failsafe or MC/ServiceGuard (from HP)? Put the real
> servers into a highly available configuration (probably with shared
> storage), then use the director to load balance connections to the
> virtual IP addresses of the HA cluster. Then you have a system that
> parallelises the database and load balances the connections. This might
> require ORACLE Open Parallel Server (OPS) edition of the database, you'd
> have to check.
My previous employer did try such a system, and had very little luck with
it. In general, you are much better off having one writer, and multiple
readers. Then, update the "read-only" databases from the write-database.
We were using Oracle Parallel Server on HP-UX, and it crashed about once
every two weeks, not always just under heavy load. Databases are by design
single entities. Trying to find a technical solution to such a
mathematical problem is asking for pain and suffering, over a prolonged
period of time.
John
--
_______________________________________
John Looney Chief Scientist
a n t e f a c t o t: +353 1 8586004
www.antefacto.com f: +353 1 8586014
|
