How to Install Percona server for MySQL 8.0 on Ubuntu 18.04 / Debian 10?. Percona Server for MySQL is a free and open source distribution of the MySQL relational database management system created by Percona. It is a fully compatible drop-in replacement for Oracle MySQL. In this guide, we will look at how to install and configure Percona MySQL Server 8.0 on Ubuntu / Debian.
For RHEL / CentOS 8: How To Install Percona MySQL Server 8 on CentOS 8 / RHEL 8
If you want to use MySQL / MariaDB database server, then check the following guides instead.
How to Install MySQL 8.0 on Ubuntu 18.04 / 16.04Â
How to Install MariaDB 10.4 on Ubuntu 18.04 / Ubuntu 16.04
How to Install MariaDB 10.4 on Debian 9 / Debian 8
A detailed feature comparison for MySQL and Percona Server for MySQL is available on this link. Below are the steps to install Percona Server for MySQL on Ubuntu and Debian Linux distributions.
Step 1: Add Percona repository
Download repository packages from Percona.
sudo apt update sudo apt install wget wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
Then Install the downloaded package with dpkg.
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
The command above will add the repository file to /etc/apt/sources.list.d/percona-release.list
Step 2: Install Percona Server for MySQL 8.0
Enable the repository:
sudo percona-release setup ps80
After enabling the repository, install Percona Server for MySQL 8.0
sudo apt install percona-server-server
Provide root password and set Select default authentication plugin when prompted. Wait for the installation to finish then login to MySQL shell.
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 8.0.13-3 Percona Server (GPL), Release '3', Revision 'a920dd6'
Copyright (c) 2009-2018 Percona LLC and/or its affiliates
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.13-3 |
+-----------+
1 row in set (0.00 sec)
mysql> QUIT;
Percona Server for MySQL 5.7 can be installed by running:
sudo apt install percona-server-server-5.7
Percona Server for MySQL 8.0 comes with the TokuDB storage engine and MyRocks storage engines. These storage engines are installed as plugins. See Percona MyRocks Installation Guide.
Step 3: Install Desktop Database Management Tool (Optional)
If working with MySQL command line is not your thing, then consider installing a Database Tool to help you. Check out our guide below:
Install and Configure DBeaver on Ubuntu 18.04 / Ubuntu 16.04 / Debian 9
Also read:
How to Install and use Percona Toolkit on Ubuntu 18.04 LTS
Monitoring MySQL and MongoDB with Prometheus and Grafana – PMM
Monitoring MySQL / MariaDB with Prometheus in five minutes
