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 Database Administrator (DBA) might do so that the cluster can almost run itself.” Not only does MPS handle availability but, Priymak noted, it also lets administrators do things such as copy the entire Facebook dataset with a single command.