Re: Database replication and WO
Re: Database replication and WO
- Subject: Re: Database replication and WO
- From: Arturo Perez <email@hidden>
- Date: Mon, 17 Oct 2005 13:56:28 -0400
Brendan Duddridge wrote:
Hi Ken,
I'd like to use replication for fail-over and load balancing purposes.
There's a Postgres project called pgcluster that might work where you
can update multiple masters, but I'm not sure if it's mature enough or
ready for production work. Has anyone here used it? I'm not even sure if
it runs on OS X Tiger Server, which is what we're using for our database
server.
There's a bunch of pgSQL replication solutions. Slony, pgcluster, etc.
BTW, if you're just migrating to pgSQL then you may want to wait for 8.1
(almost out of beta). The performance improvements are said to be
staggering.
There's also an issue with Tiger and the SHMMAX setting that was just
posted a few days ago. I don't think there's a big problem but it's
something you must be aware of while configuring pgSQL on OSX.
I was thinking of implementing the delegate
editingContextDidSaveChanges() in order to redirect inserts, updates,
and deletions to the replication master. Not sure if that would work
though, but it's an idea.
Not sure why'd you need to be aware of the replication if the database
is doing it?
-arturo
_______________________________________________
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