Heroku gussies up Postgres with database roll-back and proactive alerts

  SUMMARY:New Heroku Postgres database service features should free up DBAs to do more meaningful work, said product lead Craig Kerstiens. Heroku’s new Postgres 2.0 database service brings perks — including proactive database monitoring and alerts, and a rollback feature that is more forgiving if there’s a database snafu. The new “unlimited undo” feature, roughly analogous to Apple’s ...

Facebook tells how it makes its MySQL cluster ‘almost run itself’

Facebook has one of the largest, if not the largest, MySQL installations in the world, and has created a tool to keep that system online with as little human intervention as possible. It’s called MySQL Pool Scanner and, Facebook’s Shlomo Priymak wrote in a post on Monday describing it, it’s designed to automate ”nearly everything a conventional MySQL ...