•  

Announcement

Announcement Module
Collapse
No announcement yet.

Ubuntu 12.04 - Replacing MySQL 5.5 with latest Percona server

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

  • Ubuntu 12.04 - Replacing MySQL 5.5 with latest Percona server

    #1
    We have a large MySQL server with Innnodb and some MyISAM.
    What is the easiest way of replacing the stock MySQL with Peronca.

    From what I understand, I uneed to remove MySQL server (how about the client) through apt-remove ?
    Or do I just install percona-server through APT and it will automatically remove and install the proper packages?
    how about the command line client? (mysql-client)

    tia
    Tags: None
  • #2
    If you are upgrading from a similar version (i.e. MySQL 5.5.27 to Percona 5.5.27) then the process is fairly straight forward; just remove the old binaries and install the new binaries.

    If you will be also upgrading the version, then you'll want to replace the binaries and follow the usual MySQL upgrade process:

    http://dev.mysql.com/doc/refman/5.5/en/upgrading.html

    Comment

    • #3
      just to update this thread.
      On Ubuntu 12.04 the following packages need to be uninstalled;
      mysql-client mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5

      an easy way of replacing the standard MySQL 5.5 with Percona Mysql 5.5 is:
      Configure the Apt repository:
      http://www.percona.com/doc/percona-server/5.5/installation/a pt_repo.html

      $sudo service mysql stop <-- make sure MySQL is fully stopped. For some reason the uninstall process (below) will not stop MySQL and there will be LOCK issues with the datadir when Percona Server starts.

      $sudo apt-get install percona-server-server-5.5 percona-server-client-5.5

      It will run uninstall the needed packages and replace them with Percona:

      The following packages were automatically installed and are no longer required:
      linux-headers-3.2.0-23-generic linux-headers-3.2.0-23
      Use 'apt-get autoremove' to remove them.
      The following extra packages will be installed:
      percona-server-common-5.5
      Suggested packages:
      tinyca
      The following packages will be REMOVED:
      mysql-client mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
      The following NEW packages will be installed:
      percona-server-client-5.5 percona-server-common-5.5 percona-server-server-5.5
      0 upgraded, 3 newly installed, 7 to remove and 3 not upgraded.

      I hope I'm not missing anything.

      Comment

      • #4
        tomsk,

        Yes that's correct, you have to replace the mysql client and shared libraries like mysql-common too.

        Martin

        @martinarrietac

        Comment

        Working...
        X