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.
Certified MySQL professional with over 6 years in the MySQL community and open source. I have designed, implemented and maintained small to large scale MySQL installations. This includes building architectures from the ground up and improving on those that are currently in place while emphasizing scalability, performance and ease operations. A few of the companies I have contributed to are GoDaddy.com, Facebook.com, VMware, Virident, Plaxo.com and Ning.com. I also run a community site, EverythingMySQL.com, that promotes collaboration within the open source community.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).
View a complete list of O'Reilly MySQL Conference contacts.