All the postgresql clustering solutions are 3rd party and it's very
hard to gauge what the "production readiness" of any particular
version is. In particular,
btw -- pgcluster = spend an entire day dorking around trying to
figure out why things aren't working. FrontBase =
set default database [EMAIL PROTECTED];
create cluster;
add member [EMAIL PROTECTED]; // ... creates and replicates over to Host2
add member [EMAIL PROTECTED]; // ... creates and replicates over to Host3
start cluster;
and change your connection string to:
jdbc:FrontBase://[EMAIL PROTECTED]/[EMAIL PROTECTED]/[EMAIL PROTECTED]
replication in FrontBase is even easier, btw.
However, FrontBase is not the fastest database. PGSQL handed FB a
beating for several operations (I think maybe this is PG's MVCC
locking system showing wins? I'm not really sure though ...). I
have read in previous posts (Chuck sent me a link to it a couple
weeks ago), however, that shows that FB comes back with a vengeance
for REALLY REALLY big databases where all the others fell over.
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
