Announcement

Announcement Module
Collapse
No announcement yet.

Upgrade 5.0.98 to 5.x

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

  • Upgrade 5.0.98 to 5.x

    Hello,

    I need help, my predecessor has installed percona on one of your servers, but left no manual or whatsoever.
    We have a centos 5.9 server (64bit) and need to update/upgrade mysql version. What is the best way to do this?

    Update from 5.0 to 5.1.x or from 5.0 to 5.5.x straightaway?

    And what are the right steps to do this? I read some articles, but they are all installations from mysqld to percona mysql version.

    Preferably our downtime must be as minimal as possible.

  • #2
    Straight away. Just install the newest version, make it use the old data directory, and run the program "mysql_upgrade" that gets installed along with mysqld. That program will update your data files and may or may not run for a long while and causes downtime.

    If you want very little downtime, you need to run both versions simultaneously (with different data directories), where the newest version is a slave that replicates the old version. When they are in sync, stop replication and remove the old version.

    Comment


    • #3
      Thnx for the reply,

      Do i have to deinstall version 5.0 first and then a install of 5.5.x? or can i upgrade, if yes how?

      Comment


      • #4
        A deinstallation is not necessary though it may occur (and is not harmful) depending on the centos package manager. Just make sure you dont accidentally remove the data directory.

        Comment


        • #5
          If i do a "yum install Percona-Server-client-51 Percona-Server-server-51" i get

          file /usr/bin/mysql from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysql_find_rows from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysql_waitpid from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqlaccess from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqladmin from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqlbinlog from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqlcheck from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqldump from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqlimport from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64
          file /usr/bin/mysqlshow from install of Percona-Server-client-51-5.1.67-rel14.4.511.rhel5.x86_64 conflicts with file from package Percona-SQL-client-50-5.0.92-b23.85.rhel5.x86_64

          and a lot more. What to do?

          Comment


          • #6
            Why are you installing 5.1 instead of 5.5? Maybe remove 5.0 first.

            Comment


            • #7
              Hi gmouse,

              Thanks for the support, its working so far.
              I deinstalled the old version and installed the 5.5 version.

              Comment

              Working...
              X