0

I have MySQL community version 5.5.50 running in linux having 4-5 databases on it.

Requirement is to upgrade to Percona Server 5.6.31-77.0.

What are the pre-requisites that I need to check before upgrading? Are there any common errors that i'm likely to face?

I'm simply planning to backup the databases. Remove the MySQL binaries. Install the new Percona Server and restore the databases.

1

Backing up the database is a best practice right before upgrading to any version. You can use mysqldump, Xtrabackup, mydumper .

Replacing MySQL community packages with Percona Server packages should do the job just make sure to execute mysql_upgrade after starting up PS 5.6 the first time.

Percona Server is a free, fully compatible, enhanced, open source drop-in replacement for MySQL®

Always check the error log after the upgrade.

  • thanks can you also clarify what is the release frequency and why there are multiple versions of 5.6 in this page percona.com/downloads/Percona-Server-5.6/LATEST ? They keep releasing new version or how is it like? – tesla747 Jul 18 '16 at 2:14
  • 1
    there are different versions depending on the SSL version installed on your system. In Percona Server 5.6.24-72.2 and newer, the single binary tarball was replaced with multiple tarballs depending on the OpenSSL library available in the distribution – jerichorivera Jul 18 '16 at 2:21
  • oops sounds complicated, I use RHEL 6.4. So is it like I will have to carefully choose the right version? – tesla747 Jul 18 '16 at 2:23
  • Follow yum installation instructions instead of using generic tarballs? percona.com/doc/percona-server/5.6/installation/yum_repo.html – jerichorivera Jul 18 '16 at 2:26
  • 1
    fwiw, just run openssl version and you'd know which one you'll need to download. try this one first- percona.com/downloads/Percona-Server-5.6/…, try to use that on an empty datadir, mysqld won't start if it's not compatible with your openssl version (afaik) – jerichorivera Jul 18 '16 at 2:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.