I have been performing a few MySQL upgrades from 5.5 to 5.6. It is general a straight forward process but I wanted to discuss MySQL 5.6 parameters changes.
Showing posts with label MySQL upgrade. Show all posts
Showing posts with label MySQL upgrade. Show all posts
MySQL Upgrade and Compressed Tables
Recently one of our MySQL servers crashed. Luckily there wasn't any damage but after a support call it was found it was due to a bug with the version we are running. We decided to upgrade to the latest version of 5.5. We have one physical server running 10 small to medium MySQL instances (no replications). Whereas 9 of the upgrades went as planned one didn't (there is always one!).
Mysql 5.6 upgrade (from 5.5) single and replicated instance.
I have been working on an upgrade path from 5.5. to 5.6. The MySQL documentation is good and explains what could be a muliple phase upgrade to get to 5.5 to then upgrade to 5.6, see
Here are few notes which I hope helps. There looks to be two ways to upgrade from 5.5 to 5.6.
- Import/Export
- Binary Upgrade
Subscribe to:
Posts (Atom)