installing-perconaXTRADB Cluster 5.6

in-ubuntu-13-10-wheezy

First of all, I would recommend login as root so that you don’t have tosudo every time you hit the command and give the root password.

$ su -

Now you should be logged in as root. Mine now is

root@rajug:~#

Step 1:

First of all lets remove everything that is related to MySQL from the machine.

apt-get remove mysql*

apt-get purge mysql*

apt-get autoremeve

Step 2: Adding the key

Now lets add the key that is provided by Percona, we have to add this to beallowed to install from Percona server.

apt-key adv --keyserverkeys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

Step 3: Adding the repository

Lets add the Percona repository in the sources list in the machine/Ubuntu.

vim /etc/apt/sources.list

Add the following two lines in the source list:

http://repo.percona.com/apt/dists/

deb http://repo.percona.com/aptsaucy main

deb-srchttp://repo.percona.com/apt saucy main

Step 4: Apt-Pinning the packages

In some cases you might need to “pin” the selected packages to avoid theupgrades from the distribution repositories. You’ll need to make a new file/etc/apt/preferences.d/00percona.pref and add the following lines in it:

vim/etc/apt/preferences.d/00percona.pref

Add the following line:

Package: *

Pin: release o=PerconaDevelopment Team

Pin-Priority: 1001

Step 5: Update

$apt-get update

Step 6: Install Percona XtraDB  and Cluster

$  sudo apt-get installpercona-xtradb-cluster-56

Step 7: Install dependencies

If there are any dependencies left, then lets install them

$ apt-get install -f

Step 8: Testing

To make sure if Percona Server is installed in your machine with MySQL simplytry:

$ mysql -u root -p

And it showed me :

root@rajug:~# mysql -u root -p

mysql>