From: Peter Eisentraut <[EMAIL PROTECTED]> To: "Liam Lesboch" <[EMAIL PROTECTED]>,[EMAIL PROTECTED] Subject: Re: [GENERAL] Replication options? Date: Wed, 11 Aug 2004 21:54:28 +0200
Liam Lesboch wrote: > Thes slashdots post today about the beta releases of 8.0 caught the > attention of my boss and I. Many comments about the replicator issue > and saw many posts about Slony-I in particular. Maybe this is the > only viable option in PostgreSQL? There are others that cost money > but no where did we surface a article that spoke of them in any form > of critique or tutorial (good or bad) and thats a concern for my > boss. What large companies use replicators for PostgreSQL?
Slony-I and eRServer give you an asynchronous master/slave replication system that allows you to setup load balancing or data warehouse type things, or even failover with some replication gap. In my experience, most people don't need the load balancing part. If all you're after is securing your database system against hardware failures (which most people are after), I suggest you set up two machines with a shared storage (talk to your hardware vendor) or a replicating file system (like DRBD) and make the two machines monitor each other so that only one machine has the database mounted at any time.
The boss is seeking a system located in 5 countries and they have own copy of master servers in real time. Master->SubMaster(s) (each country) - >slaves(1-3 each country)
Make sense?
Liam
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
