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]
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
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]
During the configuration of the package, you will see the following screen where you will have to define a root password.
And then, you will have to choose the authentication plugin.
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.
