GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Percona 5.5 to MySQL 5.5 Rollback

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

  • Percona 5.5 to MySQL 5.5 Rollback

    We are evaluating Percona Server 5.5 and results are interesting. I have upgraded one of our slave from MySQL 5.1.56 to Percona Server 5.5 . It was a drop-in replacement of data files and mysql_upgrade command. Every thing is running fine .

    Is migration from Percona to MySQL is possible, if yes
    what is the procedure to Roll back to MySQL 5.5 from Percona Server 5.5 ? (If in case we need to do that in future) .

    Thanks

  • #2
    Test it!

    Going back is possible, unless you use features that break compatibility (innodb_extra_undoslots). Just install MySQL (same or newer, with mysql_upgrade being run in the latter case) and make it use the same data folder.

    Comment


    • #3
      we are using features like innodb_extra_undoslots, how will we do rollback ..............

      Comment


      • #4
        Dump all your data (mysqldump), and load it in your normal installation. This may take hours, depending on your data size and indices.

        Comment

        Working...
        X