Announcement

Announcement Module
Collapse
No announcement yet.

Copy RHEL5 to RHEL6

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

  • Copy RHEL5 to RHEL6

    Does anyone know if it is possible to copy raw MySQL data files from RHEL5 to RHEL6. From what I understand, MySQL data and log files are binary-compatible on all platforms having the same floating-point number format. Thus, transferring from one RHEL5 server to another should work. However, I have heard that RHEL6 modified the GNU C Compiler and integrated DFP support with it. Would this make it incompatible?

  • #2
    You can use binary copy of your MySQL data across any Linux platform. I don't think there is any incompatibility in GNU C that would make any problems. Of course you must stop MySQL server to make consistent copy, or use online backup tool like Percona XtraBackup.
    You can also use the same tarball MySQL or Percona Server distribution on both RHEL5/6 or Centos5/6, but regarding the RPM packages, use the dedicated ones.

    Comment


    • #3
      One important detail that I left out was that the source server, RHEL5, is running MySQL 5.1. So I am guessing that I would need to get at least get my source server on MySQL 5.5 before I could even consider the copy, correct?

      Comment


      • #4
        Not necessary. You can perform the upgrade on the destination machine. Once you've restored to the 5.5 instance run the mysql_upgrade script. http://dev.mysql.com/doc/refman/5.5/...l-upgrade.html

        Comment


        • #5
          I thought about doing that, copy the binary files from MySQL 5.1 to MySQL 5.5 on RHEL6 and then run the upgrade script. However, that seems to be very outside what Oracle recommends for doing an upgrade from 5.1 to 5.5; dump data using mysqldump and restore.

          Comment


          • #6
            For many cases binary copy and mysql_upgrade on 5.5 will just work, however indeed the safest and recommended way to upgrade 5.1 to 5.5 is to make SQL dump and restore. There are some incompatible changes and edge cases you may hit, this article is pretty long: http://dev.mysql.com/doc/refman/5.5/...us-series.html

            Btw there is faster tool then mysqldump out there, try https://launchpad.net/mydumper

            Comment

            Working...
            X