habibzain Just husband, father and enthusiastic men about System Administration. Love to write short article about it. Perhaps can help and be useful for others.

Install Percona Server for MySQL 5.6 In Ubuntu 18

1 min read

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
Percona 5.6 Ubuntu 18

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


habibzain Just husband, father and enthusiastic men about System Administration. Love to write short article about it. Perhaps can help and be useful for others.

Easy Create Laravel Project with Composer

Requirement Laravel, a popular PHP framework, is renowned for its elegant syntax and robust features, making it a top choice for web developers. One...
habibzain
1 min read

Virtualbox Change Storage Size

Changing the storage size of a virtual machine in VirtualBox involves a few steps. Here’s a general guide. Backup your Virtual Machine (VM) Before...
habibzain
35 sec read

Easy Setup Logrotate Nginx Ubuntu

Log rotation is an important aspect of managing log files on a Linux system, including those generated by Nginx. Logrotate is a utility that...
habibzain
1 min read

Leave a Reply

Your email address will not be published. Required fields are marked *

Never miss good article from us, get weekly updates in your inbox