From: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
---|---|
To: | cbbrowne(at)acm(dot)org (Christopher Browne) |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a peer-to-peer server solution with PG? |
Date: | 2005-02-04 10:56:48 |
Message-ID: | 200502041056.j14AuoCq032269@gw.tssi.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> If you have so much update load that one server cannot accomodate that
> load, then you should wonder why you'd expect that causing every one
> of these updates to be applied to (say) 3 servers would "diminish"
> this burden.
The update/query load isn't the real issue here, it's that these two
servers will be 800 miles apart and there are some advantages in having
each office connect to its local database rather than having one of
them connect to the remote master.
The Slony-1 approach will work, assuming I've got suffient network
bandwidth to support it plus the traffic from the remote office plus
exixting outside traffic from our public website.
That's one of those things you just don't know will work until you
have it built, so I'm looking for other options now while I have time
to consider them. Once I get on-site in two weeks it'll a lot more hectic.
--
Mike Nolan
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2005-02-04 11:01:47 | Re: Is there a peer-to-peer server solution with PG? |
Previous Message | Alban Hertroys | 2005-02-04 10:50:23 | Re: Invalid headers and xlog flush failures |