473,320 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 1354
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: willie | last post by:
Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to...
2
by: Stan Leung | last post by:
Hello all, I am interested in know if anyone has set up clustering for performance and fail over using PostgreSQL. We are currently using Oracle for a distribution application and would like to use...
5
by: Daniel G. Cantua | last post by:
We are thinking of starting to use clustering with our DB2 V8. I understand that with clustering when a node goes down that the other nodes will keep the database up for the users. What I would...
3
by: warwick.poole | last post by:
I am interested in finding out about Enterprise scale Postgres installations and clustering, especially on Linux. Essentially I would like to know the possibility that Postgres can store the...
0
by: brandoncli | last post by:
Volunteer-USA is looking for volunteer help to put together a MySQL cluster or replication system across a geographically distributed network. Any help or thoughts would be appreciated. Please...
4
by: torrance_bloke | last post by:
Hi, Does anyone know if DB2 has the capability to cluster in an active/active mode over geographical distances. I am aware of the replication tools and HADR capabilities but this is more...
3
by: dejavue82 | last post by:
Hi, Does anybody know of a software package that allows for several servers, running asp.net 2.0 to be clustered, regardless of where they are located (ie. without a hardware load balancer)....
5
by: Lakesider | last post by:
Hi NG, I have a question about data: I have travel-times from A to B like this from | to | sec. A B 17 A B 18 A B 30 A B 32
3
by: Manish | last post by:
I think this question has been asked number of times. However, I am looking for some specific information. Perhaps some of you can help close the gap. Or perhaps you can point me towards right...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.