Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, December 31, 1969    Matt Yonkovit

Migrating MyISAM to InnoDB

Come join us for this free hour long webinar to learn about migrating from MyISAM to Innodb

In recent releases of MySQL the default storage engine for MySQL has switched from MyISAM to Innodb. Whats does that mean? Is the world coming to an end? Are cats and dogs living together? Will your application continue to work? How will this change impact you? Should you move all your MyIsam tables to Innodb?

Many people are still running Older versions of MySQL, and still create tables with the default storage engine. We have personally seen many self proclaimed Innodb only shops with a large number of MySIAM tables. You may wonder what's the big deal? Did you know that MyISAM tables cause full table locks? Did you also know that only indexes are stored in the Key buffer, data pages still need to be read from disk? Or how about the MyISAM tables are not 100% crash safe?

Life is full of uncertainty. Let the experts at Percona help you take some of that uncertainty out of MySQL. Join us for an hour to discuss why converting now to Innodb from MyISAM can help your application in the long run. During this webinar we will help you understand the differences between the storage engines, where they are widely used, key gotchas and limitations in each of the storage engines, and finally give you idea's on how to plan and execute a migration from MyISAM.

About the Author

Matt Yonkovit

Before joining Percona, Matt worked at MySQL and Sun Microsystems as a Solution Architect, helping to build architectures for Fortune 500 and top Alexa-rated companies. Since the mid-'90s, he has worked with relational databases as a DBA, system administrator, and all around techie. During his career as a DBA, Matt has designed and supported massive database deployments that ran on MySQL, Oracle, DB2, SQL Server, Sybase, Postgres, and the AS/400. Matt has a passion for performance and spends his free time doing things like benchmarking, finding outside-the-box solutions for today's performance challenges and trying to make things just go faster.