Upgrading MySQL is boring topic, upgrading MySQL is something we would rather to be done with and get benefits from new cool features or be done with bugs and limitations which haunted us for years. Yet if you're not careful performing MySQL upgrade you can get advantage of multiple opportunities of downtime and data loss, which come as just some of the risks. There is also one special thing about upgrades - unlike many other tasks DBA has to do, major version upgrade is done only …
- High Scalability: Stuff The Internet Says On Scalability For May 11, 2012
- Engine Yard Developer Blog: Making Migrations Faster and Safer
- New Relic: Percona Bundles New Relic to Provide Gold and Platinum Support Customers with Comprehensive Application Visibility
- till's blog: Hosted MySQL: Amazon RDS (and backups)
- On the Path: Tuning MySQL
- Opscode Blog: Chef Whips Up a Mediawiki LAMP Stack for You!
A few months ago we launched an alpha release of MySQL 5.5. Today we are releasing a more robust version as a public Beta, which includes fixes and enhancements based on customer feedback. You can select MySQL 5.5 from your environment and install the Percona Server v5.5.13. The Percona build is an enhanced drop-in replacement for MySQL that allows you to run queries with greater speed and consistency.
Benefits of Upgrading
MySQL 5.5 delivers significant enhancements that enable …
- Engine Yard Developer Blog: Database Stack End of Life Announcements
- Engine Yard Developer Blog: MongoDB Best Practices
- MySQL Performance Blog: kernel_mutex problem. Or double throughput with single variable
- igvita.com: HandlerSocket: The NoSQL MySQL & Ruby
- High Scalability: Facebook at 13 Million Queries Per Second Recommends: Minimize Request Variance
- Axon Flux // A Ruby on Rails Blog: Impressive tech talk on Scaling MySQL at Facebook
Practical Advice on Upgrading
Importing your old mail can be problematic. Back up first (but you do that already, right?). When I first imported, Outlook crashed—and upon reimporting I found I had duplicated mail folders & categories. And when I started deleting some of the duplicate categories (that is, categories that were once projects), I found that Outlook started to delete thousands of messages associated with those categories. Which repeated category should you delete? Well, …