Note: I've removed -general, since this is really just a Slony discussion. On Thu, Dec 27, 2007 at 12:49:55PM -0500, Josh Harrison wrote: > We wanted to have 1 master and 1 slave that can be queried and 1 warm > standby server that can be brought up in case of crash. So I thought it > might be better to have WAL shipping for warm standby since thats working > pretty good and Slony for master-slave replication. > Let me know your comments on this setup? What is better for this setup? The disadvantage of that approach is that you have two different systems you have to maintain. You could maintain more than one Slony replica, which would have the advantage of flexibility. For instance, you could have two replicas, and in the event your origin failed, you just move the origin to one of the replicas. If one of your replicas failed, however, you could use the other replica for whatever thing the failed-replica was doing (so your "query-only" system could also be your standby while you repaired the other standby). In general, I think the best arrangement is the least complicated one. Two different replication strategies in the same mix seems to me to be the sort of complication that will make emergency recovery harder. OTOH, two different strategies presumably protects you from bugs in the other code. (For instance, a DNS company runs completely different name server code on completely different hardware and OS platforms in order to make sure not to be vulnerable to day-0 exploits. That kind of thing.) > That will be very useful since our people are debating on the reliability of > Slony for large databases!!! The size of the database is not the determining factor in Slony reliability. What is the change rate on your systems? That's the big factor in any replication system, really. Afilias's systems are quite active -- there's a _lot_ of churn on top level domains these days. A ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
