Install Percona server 5.6

Install Percona 5.6

If you already have an old copy and want to remove it and install a fresh copy, you should perform
the following commands:

   sudo apt-get update
    sudo apt-get purge -y mysql*
    sudo apt-get purge -y percona*
    sudo apt-get autoremove -y
    sudo rm -rf /etc/mysql
    sudo rm -rf /var/lib/mysql
    sudo rm -rf /etc/rc*.d/*mysql
    sudo rm -rf /var/lib/update-rc.d/mysql

Percona Installation

The following must be performed on all the nodes that will be part of the cluster. It is recommended to always use odd numbers of nodes in a cluster to avoid a split brain situation.

Create System Account
    sudo groupadd -g 3306 mysql
    sudo useradd -g 3306 -u 3306 -r mysql
 
Download Public key
    sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8507EFA5

Setup Percona Repository
    sudo vim /etc/apt/sources.list   ##Open file and add the following two lines at the end of the file
 
    deb http://repo.percona.com/apt trusty main
    deb-src http://repo.percona.com/apt trusty main

Update System
    sudo apt-get update
 
Installation
    sudo apt-get install percona-server-server-5.6

Establish basic table
    sudo service mysql stop
    mysql_install_db
 
Start MySQL
    sudo /etc/init.d/mysql start