Hi again,
On 17/04/2007, at 12:20 PM, Mike Schrag wrote:
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]
Out of interest, is this fallback hosts list a general option for any
jdbc connection dictionary? Or is this something frontbase adds?
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.
Thanks very much for all the info Mike. That's very useful.
with regards,
--
Lachlan Deck
_______________________________________________
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]
