GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Steps to upgrade minor version of Percona/Mysql Server

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steps to upgrade minor version of Percona/Mysql Server

    Hi,
    I'm new here. I’ve just moved from Mysql 5.6 to Percona 5.6.
    Though MySQL community mark version 5.6.13 as GA, I'm still interested in upgrade minor version in my production server.
    I’m struggling search over the Internet how to upgrade minor version of both Percona & Mysql server but got no luck. All of them talk about "mysql_upgrade" but I find no instruction how to use it.
    Currently I have to stop the server, do a mysqldump, uninstall it & install a newer version in CentOS since my database is quite small.
    1. Is there a better way to upgrade minor version of Percona?

    2. One more thing, is there a way to convert my current InnoDB table (MySQL 5.6) to XtraDB (Percona 5.6)? Make a dump -> export to an SQL file, replace ENGINE from INNODB -> XTRADB, that’s it ???
    Regards,

  • #2
    Oracle MySQL and Percona MySQL are binary compatible unless you use a select few options, so in most cases no special consideration needs to be given when moving between the two if the version is the same. When using Percona Server, you do not make a table "XtraDB", it is just InnoDB with XtraDB code on the backend. So if you want to convert to XtraDB, just replace your Oracle MySQL binaries with Percona Server binaries.

    Minor upgrades are generally as simple as shutting down the server, removing the old binaries, installing the new binaries, starting MySQL, and running mysql_upgrade. If you do a large upgrade (i.e. major version, or some critical minor version that may have bigger implications), then it is recommended that you take a logical backup (i.e. mysqldump) and import that into a clean install of the new binaries.

    Comment

    Working...
    X