Upgrading from 5.x to 5.5
- upgrading from mysql 5.0.xx to 5.5
I wouldn't say it's straightforward. It depends on how risk-tolerant you are. At a minimum, the mysql_upgrade process needs to happen. I believe that if the data is important, using pt-upgrade to validate that everything still works as expected afterwards is also pretty much a minimal requirement for such a big upgrade. The MySQL manual's upgrading pages for each major version, and the changelogs between those versions, are important to read too. One of the things I try to make everyone aware of when upgrading from 5.0 -> 5.1+ is the change in some of the charset/collations that happened in 5.1.24
In specific this changelog.
This percona blog post mentions the compatibility patches introduced in 5.1.58 by percona:
http://www.mysqlperformanceblog.com/2011/08/17/percona-serve r-5-1-58-12-9/
MySQL Admin Tools[]
mysql utilities; innotop.noarch : A MySQL and InnoDB monitor program maatkit.noarch : Essential command-line utilities for MySQL mysqlreport.noarch mysqltuner.noarch mysql-utilities.noarch : Scripts for managing and administering MySQL servers mysql-workbench.x86_64 : A MySQL visual database modeling, administration and querying tool mytop.noarch