Not the answer you need?
Register and ask your own question!

upgrade percona 5.5 to latest version of 5.5

dbeatodbeato EntrantCurrent User Role Beginner
I am writing since we have a percona 5.5 master -slave setup on our system. We had performed the package upgrade on ubuntu and it upgraded the percona 5.5 client and server on the slave before the Master. Once the master was upgraded it could not be accessed unless direclty on the command line. If we stopped the slave mysql then it would connect to the Master. I am wondering what would be the best recommendations on how to upgrade the client and server of the same major version with updates.

Comments

  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi dbeato;

    Make sure to run mysql_upgrade, and also check to see if your my.cnf (or whatever config file you use) is still being used and was not overwritten.

    https://dev.mysql.com/doc/refman/5.5/en/replication-upgrade.html

    -Scott
  • dbeatodbeato Entrant Current User Role Beginner
    Thanks, I will be reviewing this. An upgrade of the slave before the master would cause the master to not allow connection after the master is upgraded to the latest version?
  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Hi dbeato;

    It has to do with the upgrade of your master; either your config file was changed and is now preventing access, or your permission tables are not in a happy state and that is causing rejected connections.

    So running mysql_upgrade should fix any possible permission problems, and then you'll have to manually verify that the config file you use was not changed and that MySQL is actually using it still.

    -Scott
  • dbeatodbeato Entrant Current User Role Beginner
    Yes, that is what I suspected.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.