469,903 Members | 1,902 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,903 developers. It's quick & easy.

Clustering, mirroriing, or replication?

We're trying to figure out how we can implement a reasonably simple cluster
of postgres servers on a private network at our store locations. The idea
is to have a group of 2-6 PCs each be able to share data in a replicated
manner. Having a separate database server is not an option due to the
immense cost and logistics (we have over 800 stores), so we need to find a
way to mirror or replicate data between all the nodes currently up and on
the network. Some nodes might be not always be up, so we need a failover
system. I'm testing to see if the dbmirror that comes with Postgres will
work, but I haven't got it completely figured out yet.

If anyone has experience setting up and maintaing clusters with
replication/mirroring, I'd like to hear of your experience and maybe pick
your brain a little. Any help you could give would be excellent!
Thanks!

Jon Brisbin
=======================================
Development Programmer
NPC International
(620) 235-7726

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #1
1 1263
Jon Brisbin wrote:
We're trying to figure out how we can implement a reasonably simple cluster
of postgres servers on a private network at our store locations. The idea
is to have a group of 2-6 PCs each be able to share data in a replicated
manner. Having a separate database server is not an option due to the
immense cost and logistics (we have over 800 stores), so we need to find a
way to mirror or replicate data between all the nodes currently up and on
the network. Some nodes might be not always be up, so we need a failover
system. I'm testing to see if the dbmirror that comes with Postgres will
work, but I haven't got it completely figured out yet.


I'm talking well out of my experience here, having never tried to set up
800 sets of desktop PCs as replicated shared DB servers, but I can't
believe it's more expensive to put servers in. In my experience, even a
cheap white-box dedicated server is more reliable than a PC being used
for desktop apps.

Assume each user kicks the power cable out of their PC once a year, that
means you'll be dealing with several failovers a day on average.

Assuming you can't get a server for each store (that'd be a minimum of
400 * 800 = 320,000 in the UK), is there any networking between them?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Daniel G. Cantua | last post: by
3 posts views Thread by warwick.poole | last post: by
reply views Thread by brandoncli | last post: by
4 posts views Thread by torrance_bloke | last post: by
3 posts views Thread by dejavue82 | last post: by
5 posts views Thread by Lakesider | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.