Postgres Replication on 9.1
Our new PowerDNS cluster (of 2 nodes, so far).. Is backed by Postgresql. In the past, I’ve found that Postgres performs far better for a PowerDNS backend, than MySQL, and certainly better than the BIND, LDAP or SQLite backends. Until version 9.x, Postgres replication was a pretty sorry state of affairs. There were a few options for replication. Slony was commonly used, if not very good.. You’d tend to get a horrific SPoF around the single master. In total, there were 9 or 10 different third party solutions for Postgres replication and clustering. They all had their pros and cons, and some were great, and some were downright awful. ...