Re: Anyone used sequoia?
Re: Anyone used sequoia?
- Subject: Re: Anyone used sequoia?
- From: Lachlan Deck <email@hidden>
- Date: Tue, 17 Apr 2007 12:28:43 +1000
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 MyDB@Host1;
create cluster;
add member MyDB@Host2; // ... creates and replicates over to Host2
add member MyDB@Host3; // ... creates and replicates over to Host3
start cluster;
and change your connection string to:
jdbc:FrontBase://MyDB@Host1/MyDB@Host2/MyDB@Host3
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden