ubuntu
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.
1. $ su -
$ su -
now you should be logged in as root. mine now is
1. root@rajug:~#
root@rajug:~#
step 1:
first of all lets remove everything that is related to mysql from the machine.
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 that is provided by percona, we have 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 two 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 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:
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 are 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 is installed in your machine with mysql simplytry:
1. $ mysql -u root -p
$ mysql -u root -p
and it showed me :
root@rajug:~# 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) 2000, 2013, oracle and/or its affiliates. all rights reserved.
8.
9. oracle is a registered trademark of oracle corporation and/or its
10.affiliates. other names may be trademarks of their respective
11.owners.
12.
13.type 'help;' or '/h' for help. type '/c' to clear the current input statement.
14.
mysql>