How to install Percona on Ubuntu 20.04?

Windows Articles

The new Windows 10 file explorer will arrive with 21H2 update.

Hello! Microsoft does not stop working (except at Christmas) to continue polishing to Windows 10. In fact, users are gradually receiving the...

How to create an FTP server in Android

Hello! How are you? Currently sharing files from your PC to Android can be more comfortable and easy, without the need to...

Installing Taskwarrior – TODO list from the command line

Hello, friends. You know we really like the terminal. That's why today we will help you installing Taskwarrior on Linux. With this...

Use Windows 10 as a hacking system by installing Kali Linux

Hello! Windows and GNU/Linux is a relationship that was previously similar to water and oil. In fact, the differences were so vast...

How to create a Widget of any Web page in Android

Android widgets are one of the flagship features of Google's mobile operating system. The possibilities of customization of widgets are endless. Imagine...
angeloma
angeloma
Senior Writer and partner

Hi, folks. In this post, we will show you how to install Percona on Ubuntu 20.04. With Percona you will have a relational database manager compatible with MySQL but with many technical innovations that make it quite competitive.

Percona and MySQL

Percona Server is a MySQL fork. This makes it 100% compatible with this one, including commands and configurations. In the beginning, it was a community project but today it has a company behind it that offers mainly even more efficiency than MySQL for a lower cost. Percona Server also includes XtraDB which is a fork of the InnoDB engine that makes the application more efficient.

As expected, Percona also has a free version that we can install without problems and is available for Linux.

Thanks to the associated tools of Percona, it is possible to monitor and keep statistics of the performance of the database. On the other hand, Percona also includes in its products an alternative to Galera, which allows us to build our clusters with full compatibility with it.

Install Percona on Ubuntu 20.04

Percona does not come in the official Ubuntu 20.04 repositories, but it is not very difficult to install it either. All these thanks to the dedicated repository that the development team provides us with.

So, open a terminal and download the DEB package that adds and configures the Percona repository.

:~$ wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
--2020-06-14 20:10:52-- https://repo.percona.com/apt/percona-release_latest.focal_all.deb
Resolving repo.percona.com (repo.percona.com)… 167.99.233.229, 167.71.118.3, 157.245.119.64
Connecting to repo.percona.com (repo.percona.com)|167.99.233.229|:443… connected.
HTTP request sent, awaiting response… 200 OK
Length: 9910 (9.7K) [application/octet-stream]
Saving to: ‘percona-release_latest.focal_all.deb’
percona-release_latest.focal_all.deb 100%[=====================================================================================>] 9.68K --.-KB/s in 0s
2020-06-14 20:10:54 (36.3 MB/s) - ‘percona-release_latest.focal_all.deb’ saved [9910/9910]
1.- Downloading the DEB package for Percona repository
1.- Downloading the DEB package for Percona repository

Then proceed to install it with gdebi. If you do not have gdebi installed you can install it with the following command:

:~$ sudo apt install gdebi

Now, install the downloaded DEB.

:~$ sudo gdebi percona-release_latest.focal_all.deb
Reading package lists… Done
Building dependency tree
Reading state information… Done
Reading state information… Done
Package to install Percona gpg key and APT repos
Do you want to install the software package? [y/N]:y
/usr/bin/gdebi:113: FutureWarning: Possible nested set at position 1
c = findall("[(/\S+[])]", msg)[0].lower()
Selecting previously unselected package percona-release.
(Reading database … 156611 files and directories currently installed.)
Preparing to unpack percona-release_latest.focal_all.deb …
Unpacking percona-release (1.0-19.generic) …
Setting up percona-release (1.0-19.generic) …
Enabling the Percona Original repository
<*> All done!
==> Please run "apt-get update" to apply changes
The percona-release package now contains a percona-release script that can enable additional repositories for our newer products.
For example, to enable the Percona Server 8.0 repository use:
percona-release setup ps80
Note: To avoid conflicts with older product versions, the percona-release setup command may disable our original repository for some products.
For more information, please visit:
https://www.percona.com/doc/percona-repo-config/percona-release.html
2.- Adding the Percona repository
2.- Adding the Percona repository

This repository has several products that we can install. Therefore, we have to configure which one we want. Since we are interested in installing Percona 8, execute this command:

:~$ sudo percona-release setup ps80

Now, install Percona with the following command:

:~$ sudo apt install percona-server
Reading package lists… Done
Building dependency tree
Reading state information… Done
The following packages were automatically installed and are no longer required:
galera-3 libconfig-inifiles-perl libdbi-perl libsnappy1v5 mysql-common socat
Use 'sudo apt autoremove' to remove them.
The following additional packages will be installed:
debsums libfile-fnmatch-perl libmecab2 percona-server-client percona-server-common
The following NEW packages will be installed:
debsums libfile-fnmatch-perl libmecab2 percona-server-client percona-server-common percona-server-server
0 upgraded, 6 newly installed, 0 to remove and 52 not upgraded.
Need to get 50.2 MB/55.1 MB of archives.
After this operation, 404 MB of additional disk space will be used.
Do you want to continue? [Y/n]
3.- Installing Percona on Ubuntu 20.04
3.- Installing Percona on Ubuntu 20.04

During the configuration of the package, you will see the following screen where you will have to define a root password.

4.- Set a root password
4.- Set a root password

And then, you will have to choose the authentication plugin.

5.- Configuring Percona on Ubuntu 20.04
5.- Configuring Percona on Ubuntu 20.04

Then the whole process will continue and you will be ready for action.

Remember that as with MariaDB and MySQL, you can run the mysql_secure_installation script and change the root key to further secure the installation.

So, enjoy it.

Also, you can read our post about Graphical Clients for MySQL.

Graphical clients for SQL in Linux

Conclusion

Percona is a software wonder. It inherits the best of MySQL but gives an extra technical touch that is necessary for many projects. So, you have been able to install it in Ubuntu 20.04 and now it remains to continue using it in your projects.

So, share this post, join our Telegram Channel and buy us a coffee.

More articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest article

The new Windows 10 file explorer will arrive with 21H2 update.

Hello! Microsoft does not stop working (except at Christmas) to continue polishing to Windows 10. In fact, users are gradually receiving the...

How to create an FTP server in Android

Hello! How are you? Currently sharing files from your PC to Android can be more comfortable and easy, without the need to...

Installing Taskwarrior – TODO list from the command line

Hello, friends. You know we really like the terminal. That's why today we will help you installing Taskwarrior on Linux. With this...

Use Windows 10 as a hacking system by installing Kali Linux

Hello! Windows and GNU/Linux is a relationship that was previously similar to water and oil. In fact, the differences were so vast...

How to create a Widget of any Web page in Android

Android widgets are one of the flagship features of Google's mobile operating system. The possibilities of customization of widgets are endless. Imagine...
x