4 ms·

By non-free clustered version, are you referring to Slony (http://slony.info/ http://slony.info/) ? I believe you can use it for free, and I have known people

• zach 19y ago
  That's how the Reddits did it.
  • davidw 19y ago
    They use Postgres? I hadn't seen that before.
    • dood 19y ago
      From 11 months ago: [http://programming.reddit.com/info/jl2a/comments/cjpfw http://programming.reddit.com/info/jl2a/comments/cjpfw] " We use postgresql + slony, and are fairly pleased. Most of the time reddit slows down, it's db related, but so far there has always been a way to work through it. That being said, I feel we have to spend far too much time worrying about the database, and that's probably the situation with any relational db. Presently, we have a db master that replicated to one machine, and that second machine replicates to a couple others. Most of the reddit queries are handled by the master and the first slave. The other slaves are used for backups and slow queries (e.g. stats and recommendations). Replication and query load-balancing helped out a lot with the database load, but it introduced a new host of problems. Replication lag, in particular. This occurs when a db write is committed to the master, but the next read hits a slave before the write has propagated. "
• deleted 19y ago
  [deleted]