Facebook open source MySQL utility

Facebook has open sourced a MySQL utility, OSC (Online Schema Change), which it uses to change server schemas on its live systems. The problem Facebook faced was that when it needed to change the structure of its MySQL databases on live systems, using ALTER TABLE statements took too long.

Facebook found an existing tool in openark kit MySQL utility collection, oak-online-alter-table, which used MySQL 5.0 triggers to speed the process of a non-blocking ALTER TABLE operation.

Read more at H-online

Comments are closed.