Back to Browse

Zero Downtime Schema Changes in MySQL

6.9K views
Nov 21, 2013
1:01:17

Do schema changes ("migrations") require a lot of advance scheduling and impact your development and business progress? Is an ALTER TABLE on the critical path in your project planning chart? This common problem comes from the fact that most ALTER operations in MySQL cause the table to be locked and rebuilt, which can be a long and intensive process. Learn how Percona Toolkit's pt-online-schema-change tool makes these issues a thing of the past. With pt-online-schema-change, you can alter huge tables while reads and writes continue without interruption. Presented by Baron Schwartz at Percona Webinars -- May 2nd, 2012. His slides are available here: http://www.percona.com/files/presentations/WEBINAR-zero-downtime-schema-changes.pdf

Download

1 formats

Video Formats

360pmp452.8 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Zero Downtime Schema Changes in MySQL | NatokHD