On Fri, 12 Apr 2002, John Orthoefer wrote:
> I don't think it's right to call it "nearly impossible". If you dump
> your e-mail into an Oracle DB, you can use Oracle to keep each
> transaction against several datastores in sync. And I can't claim to be
> a DBA or anything but I've been told that Oracle can keep several copies
> of a database in-sync with fall-back servers and all.
I've setup Oracle replication in the past, and there are two forms:
master/slave and multi-master. The difference is basically that updates
can either only be done on one machine and then snapshotted to other
machines, or whether updates can be done on each master. The latter is
more complicated, but is necessary if you want to continue to make updates
while the other server is down.
Oracle multimaster replication isn't for the faint of heart, and it
doesn't scale to hundreds of servers but can handle a relatively small
number of servers. (1 to maybe 5 where 5 would probably scare me, and 2
or 3 might be reasonable)
Allegedly, you should have oracle enterprise to do this.
--Dean
---
Send mail for the `bblisa' mailing list to `[EMAIL PROTECTED]'.
Mail administrative requests to `[EMAIL PROTECTED]'.
