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.

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
8
  • 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
    Commented Jul 18, 2016 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
    Commented Jul 18, 2016 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
    Commented Jul 18, 2016 at 2:23
  • Follow yum installation instructions instead of using generic tarballs? percona.com/doc/percona-server/5.6/installation/yum_repo.html
    – jerichorivera
    Commented Jul 18, 2016 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
    Commented Jul 18, 2016 at 2:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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