MySQL table alterations can interrupt production traffic causing bad customer experience or in worst cases, loss of revenue. Not all DBAs, developers, syadmins know MySQL well enough to avoid this pitfall. DBAs usually encounter these kinds of production interruptions when working with upgrade scripts that touch both application and database or if an inexperienced admin/dev [&]

The post Avoiding MySQL ALTER table downtime appeared first on MySQL Performance Blog.

http://www.percona.com/blog/2014/11/18/avoiding-mysql-alter-table-downtime/