Under the Hood - MySQL Pool Scanner (MPS)
4 April 3:00PM - 3:50PM @ Ballroom F
50 minutes conference
Facebook has one of the largest MySQL database clusters in the world, comprising thousands of servers across multiple data centers. Operating a cluster of this size requires automating most of what a conventional MySQL Database Administrator (DBA) might do, so that the cluster can almost run itself. Learn about the design and architecture of our robo-DBA, written in Python, plus a few war stories.
MySQL Database Engineer, Facebook
Shlomo has been on the MySQL Operations team at Facebook since 2011, managing one of the biggest MySQL clusters in the world — mostly by being lazy and making automation manage it instead of him. Before making the switch to manage 1000s of MySQL servers, Shlomo was pretty happy with 100s of them at companies like Sears and Wix, where he was a DBA and a developer. Prior to diving into to the MySQL world in 2006, Shlomo used to be a SQL Server DBA at the Israeli Intelligence Corps, but he can't tell you how many servers he managed there.