Case study reviewing iParadigm's (Turnitin's) growth to 3000 queries per second, and the replication and hardware decisions incorporated to meet increased demand. Presented at PGWest Conference 2010
in 1996 Creators of Turnitin.com, the leading provider of academic integrity services to schools and universities worldwide Creators of iThenticate.com, an up-and-coming service for publications and journals
wrote our own Multiplexor to use slaves as read-only copies Failover/Switchover Provided recovery plan -- whew! Enabled easy upgrades Delayed replication
wrote our own Multiplexor to use slaves as read-only copies Failover/Switchover Provided recovery plan -- whew! Enabled easy upgrades Delayed replication Log Shipping (will discuss in a bit)
real estate Short-stroking RAID drives provides almost equal performance at similar cost Price of SSD is dropping! Planning to move to Virident shortly
in pg_xlog! table bloat -- don’t let autovacuum bite you (8.4 resolves this) slony failover not working -- found race condition idle transactions -- keep an eye on them