Faster Than Alter - Less Downtime

Although ALTER will always have its place in MySQL, there are faster ways to change schema which cause little to no customer facing downtime! This presentation will cover the following topics:

1. Alter table vs Load Data INFILE
2. De-fragmentation of data sets
3. Using Slave servers to help minimize downtime
4. Real world situations from three companies
*Schema change on large 70+GB MyISAM table
*De-fragmentation of Innodb data sets (Golden Gate)
*Throwing in Fusion I/O to make it even faster

This will be a informative talk about real world problem solving and the powerful yet sometimes overlooked LOAD DATA INFILE command. This talk is for MySQL DBAs who want to expand their knowledge, improve performance and decrease customer facing downtime.