Upgrade MySQL 5.1.36 CE to Percona Server 5.6

MySQL & MariaDB Other MySQL® Questions
1

Hi,

I have a smaller server for hosting some dozens of web sites for me and my friends and I am impressed with Percona descriptions. Would like to give it a go with in-place replacement.

Now, how to do it?

My server is Ubuntu 64-bit 10.04.4 LTS (639-core, pentabytes of ram, ssd disks etc blah blah…) and I am running at the moment:

  • MySQL 5.1.72 Community
  • PHP 5.3.2 + Suhosin Patch 0.9.9.1
  • ISP Config control panel (!!)

All users are chrooted, jailkit in use.

Now, looking for advice on how to do in-place upgrade from MySQL to Percona Server and to retain all users, paths, databases etc.
Not to mention, need to keep compatibility with ISP Config control panel, which has control over MySQL databases and users.

Please, kick me in the right direction :slight_smile:

2

Hi,

It’s not recommended to upgrade MySQL from 5.1 to direct 5.6. So you’ll have to upgrade first from 5.1 to 5.5 and then 5.5 to 5.6. You can check below links for the procedures that how to do it.

[URL]Percona Server for MySQL 8.0 - Documentation — Percona Server 8.0 Documentation
[URL]Percona Server for MySQL 8.0 - Documentation — Percona Server 8.0 Documentation

For Ubuntu, you can check [URL]Percona Server In-Place Upgrading Guide: From 5.1 to 5.5