Percona XTRADB Cluster 5.6 in Ubuntu installation

INSTALLING-PERCONAXTRADB Cluster 5.6

In-ubuntu-13-10-wheezy

First of all, I would recommend login as root so this you don ' t has tosudo every time you hit the command and give the RO OT password.

1. $ SU-

$ Su-

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

1. [Email protected]:~#

[Email protected]:~#

Step 1:
First of all lets remove everything, that's related to MySQL.

1. apt-get Remove mysql*

2. Apt-get purge mysql*

3. Apt-get Autoremove

Apt-get Remove mysql*

Apt-get Purge mysql*

Apt-get Autoremeve

Step 2:adding the key
Now lets add the key, which is provided by Percona, we had to add this to beallowed to install from Percona server.

1. apt-key adv--keyserver keys.gnupg.net--recv-keys 1c4cbdcdcd2efd2a

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.

1. vim/etc/apt/sources.list

Vim/etc/apt/sources.list

Add the following lines in the source list:

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

1. deb http://repo.percona.com/apt wheezy main

2. deb-src http://repo.percona.com/apt wheezy main

Deb Http://repo.percona.com/aptsaucy Main

Deb-srchttp://repo.percona.com/apt Saucy Main

Step 4:apt-pinning the Packages
In some cases-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:

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

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

Add the following line:

1. Package: *

2. pin:release O=percona Development Team

3. pin-priority:1001

Package: *

Pin:release o=perconadevelopment Team

pin-priority:1001

Step 5:update

1. $apt-get Update

$APT-get Update

Step 6:install Percona Server and Client

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

$ apt-get installpercona-server-server-5.6 percona-server-client-5.6

Step 7:install Dependencies
If There is any dependencies left, then lets install them

1. $ apt-get install-f

$ apt-get Install-f

Step 8:testing
To make sure if Percona Server are installed in your machine with MySQL simplytry:

1. $ mysql-u root-p

$ mysql-u Root-p

And it showed me:

[Email protected]:~# mysql-u root-p

1. Enter Password:

2. Welcome to the MySQL Monitor. Commands End With; or \g.

3. Your MySQL Connection ID is 11

4. Server version:5.6.15-63.0 Percona Server (GPL), Release 63.0

5.

6. Copyright (c) 2009-2013 Percona LLC and/or its affiliates

7. Copyright (c), +, Oracle and /or its affiliates. All rights reserved.

8.

9. Oracle is a registered trademark of the Oracle Corporation and/or its

Ten. affiliates. Other names trademarks of their respective

One by one . owners.

.

Type ' help ; ' or ' \h '  for help. Type ' \c ' to clear the current input statement.

.

Mysql>