How to install Percona on Ubuntu 20.04?

Windows Articles

How to install GNU Fortran on Ubuntu 20.04 / 18.04?

Not everything old is bad. This is how it is. Well, while it is true that there are many programming languages today, there are...

How to install Unity Desktop on Ubuntu 20.04?

Unity Desktop was for a long time the default desktop environment in Ubuntu. Thanks to this, Ubuntu gained a great personality and...

How to install Android on a PC with Phoenix OS

Hello! Android is the most widely used mobile operating system in the world. Indeed, this Linux-based system has a large market share....

How to install Apache Maven on OpenSUSE 15.2 / 15.1?

In this post, we will show you how to install Apache Maven on OpenSUSE 15.2 / 15.1. To manage projects done in Java, there is...

How to install SQLite on OpenSUSE 15.2 / 15.1?

There are many good database management systems, but they are not all the same. And the fact that they are not, means...
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

How to install GNU Fortran on Ubuntu 20.04 / 18.04?

Not everything old is bad. This is how it is. Well, while it is true that there are many programming languages today, there are...

How to install Unity Desktop on Ubuntu 20.04?

Unity Desktop was for a long time the default desktop environment in Ubuntu. Thanks to this, Ubuntu gained a great personality and...

How to install Android on a PC with Phoenix OS

Hello! Android is the most widely used mobile operating system in the world. Indeed, this Linux-based system has a large market share....

How to install Apache Maven on OpenSUSE 15.2 / 15.1?

In this post, we will show you how to install Apache Maven on OpenSUSE 15.2 / 15.1. To manage projects done in Java, there is...

How to install SQLite on OpenSUSE 15.2 / 15.1?

There are many good database management systems, but they are not all the same. And the fact that they are not, means...