Forum Stats

  • 3,854,674 Users
  • 2,264,399 Discussions
  • 7,905,751 Comments

Discussions

upgrade repository to tar install

user4255753
user4255753 Member Posts: 2 Blue Ribbon
edited Jul 27, 2016 4:10PM in MySQL Community Space

Howdy folks,

My shop is looking at moving and upgrading our MySQL databases(v5.6.21) from a Linux x86-64bit Red Hat repository installation to a TAR install(v5.6.30) on the same server.

Our ideal scenario would be that we could install the TAR version, shut down our databases and start them up in upgrade mode pointed at the TAR install.

At worst case we would try and restore the databases to the TAR install.

This almost makes it sound like that our ideal isn't achievable and we'll have to remove our old installation AND databases:

https://dev.mysql.com/doc/refman/5.6/en/binary-installation.html

"If you have previously installed MySQL using your operating system native package management system, such as yum or apt-get, you may experience problems

installing using a native binary. Make sure your previous MySQL installation has been removed entirely (using your package management system), and that any additional files,

such as old versions of your data files, have also been removed."

Does anyone have any idea if our upgrade is feasible?

-Brian

Best Answer

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 374 Employee
    edited Jul 27, 2016 10:23AM Answer ✓

    Yes, you can do it.  The big question is why are you going from RPMs to tar?  Is it so that you can roll back to the earlier version if things go wrong? 5.6.21 to '30 is not a drastic jump BTW '31 is available. you would have a much easier time simply upgrading via RPM.

    Dave Stokes

    MySQL Community Manager

    user4255753

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 374 Employee
    edited Jul 27, 2016 10:23AM Answer ✓

    Yes, you can do it.  The big question is why are you going from RPMs to tar?  Is it so that you can roll back to the earlier version if things go wrong? 5.6.21 to '30 is not a drastic jump BTW '31 is available. you would have a much easier time simply upgrading via RPM.

    Dave Stokes

    MySQL Community Manager

    user4255753
  • user4255753
    user4255753 Member Posts: 2 Blue Ribbon
    edited Jul 27, 2016 4:10PM

    Thank you for the answer David. We're an Oracle database shop so MySQL things are still a bit new to us.

    The why is sadly not up to our shop to decide. It's being directed from above us as security requirements and "seperation of duties" between the linux admins and the database team.