Re:Disqus: Scaling the World’s Largest Django Application (2...
by hahainternet on Thursday November 22, 2012 @06:21AM
(#4818371)
What struck me instantly was the use of Slony. I haven't listened to the whole thing yet but I am interested in their justification. Perhaps they just haven't moved to 9.2 yet.
[ Parent
| on HN ]
Re:Disqus: Scaling the World’s Largest Django Application (2...
by sugarcode on Thursday November 22, 2012 @02:14PM
(#4819724)
slony offers some compelling advantages over streaming replication - even on new databases we setup, we still like slony for several reasons:
* Version upgrades (streaming replication requires the same PG version between master/slave, slony does not)
* Logical replication gives us finer-grained control over how data is replicated across the cluster
* Ability to create additional indexes on slaves
slony isn't perfect and it has caused us some headaches, but its flexibility makes it our go-to replication tool for postgres.