Install Percona Server for MySQL 5.6 In Ubuntu 18

Hi Dude. In this article, I will show you how to install Percona MySQL 5.6 on Ubuntu 18.04 LTS. Percona MySQL is a drop-in replacement for MySQL that offers better performance, stability, and scalability. Percona MySQL also comes with XtraDB, a fork of InnoDB that improves efficiency and throughput, and PAM authentication, a feature that allows you to integrate your database access with your existing authentication scheme.

Before we begin, make sure you have root access to your Ubuntu 18.04 server, and at least 1 GB of memory. If you have an existing MySQL or MariaDB installation, you should back up your data before proceeding. You can also install Percona MySQL from scratch on a new server.

Percona Server for MySQL 5.6 is depreated in official web percona. But don’t worry, we can still install Percona 5.6 via this PDF archive. Downloadable.

Important Note: We just found percona 5.6 in Ubuntu 18 and earlier.

Install Percona Server for MySQL 5.6 From Repository

The first step is to download the deb-bundle file from the Percona MySQL 5.6 download page:

1. Install GnuPG, the GNU Privacy Guard:

$ sudo apt-get install gnupg2

2. Fetch the repository packages from Percona web:

$ wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb

3. Install the downloaded package with dpkg. To do that, run the following commands as root or with sudo:

$ sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb

Once you install this package the Percona repositories should be added. You can check the repository setup in the /etc/apt/sources.list.d/percona-release.list file.

4. Remember to update the local cache:

$ sudo apt-get update

5. After that you can install the server package:

$ sudo apt-get install percona-server-server-5.6

habibza@server02:~ apt-get install percona-server-server-5.6

Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libmysqlclient20 libperconaserverclient18.1 mysql-common percona-server-client-5.6 percona-server-common-5.6
Suggested packages:
  libclone-perl libmldbm-perl libnet-daemon-perl libsql-statement-perl tinyca
The following NEW packages will be installed:
  libaio1 libdbd-mysql-perl libdbi-perl libmysqlclient20 libperconaserverclient18.1 mysql-common percona-server-client-5.6 percona-server-common-5.6 percona-server-server-5.6
0 upgraded, 9 newly installed, 0 to remove and 0 not upgraded.
Need to get 17.9 MB of archives.
After this operation, 154 MB of additional disk space will be used.
Do you want to continue? [Y/n] Y

If any prompt input password root mysql, please fill with strong password. After install finished, login in terminal command line with root password.

 mysql -uroot -p

That’s it! You have successfully installed Percona MySQL 5.6 on Ubuntu 18.04 LTS. Maybe Usefull.