MySQL Cheat Sheet

MySQL Replication

MySQL Users & Passwords

Upgrading from 5.x to 5.5

  1. 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: r-5-1-58-12-9/

MySQL Admin ToolsEdit

mysql utilities;
innotop.noarch : A MySQL and InnoDB monitor program
maatkit.noarch : Essential command-line utilities for MySQL
mysql-utilities.noarch : Scripts for managing and administering MySQL servers
mysql-workbench.x86_64 : A MySQL visual database modeling, administration and querying tool