Migrating Large Databases to utf8mb4 with Online Schema Change

This is a past event

34 people went

Every 2nd Monday of the month

Location visible to members

Details

David Berube will present "Migrating Large Databases to utf8mb4 with Online Schema Change".

Many MySQL databases are using the old default utf8 encoding for MySQL, and some are even still using latin1 - but for many installs, the downtime associated with a migration can be difficult or impossible.

This talk will discuss using online schema change tools to quickly and efficiently migrate databases with zero downtime and reduced impact on server performance.

About the Speaker:

David Berube is a freelance programmer and MySQL consultant, speaker, and author; he wrote the books "Practical Ruby Gems" and "Practical Reporting with Ruby on Rails," and co-wrote "Practical Rails Plugins." He's spoken at Percona Live!, Pearson's Voices that Matter, and many other venues.

His website is http://berubeconsulting.com/

------------- Logistics -------------

MIT's map with the building (E51) highlighted: http://whereis.mit.edu/map-jpg?selection=E5... (http://whereis.mit.edu/map-jpg?selection=E51&Buildings=go)

MIT's map with the Kendall square T stop highlighted: http://whereis.mit.edu/map-jpg?selection=L5... (http://whereis.mit.edu/map-jpg?selection=L5&Landmarks=go) (the stop is in red on that map, and you can see E51 in the bottom right)

MIT's maps with parking lot information: http://whereis.mit.edu/map-jpg?selection=P4... (http://whereis.mit.edu/map-jpg?selection=P4&Parking=go) and http://whereis.mit.edu/map-jpg?selection=P5... (http://whereis.mit.edu/map-jpg?selection=P5&Parking=go)

Note that MIT lots are free to park in after 3 pm or so, even if it says "reserved for faculty"

Free pizza will be served, so please RSVP accurately.

To RSVP anonymously, please login to the Meetup site with the e-mail address "admin at sheeri dot com" and the password "guest". For more information, see: http://www.meetup.com/mysqlbos/calendar/