How to Install Percona server for MySQL 8.0 on Ubuntu 24.04|22.04|20.04?. 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.

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.

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.

1. Add Percona repository

Download repository packages from Percona.

sudo apt update && sudo apt install wget -y
wget  https://repo.percona.com/apt/percona-release_latest.generic_all.deb

Then Install the downloaded package with dpkg.

sudo apt install gnupg2 lsb-release ./percona-release_latest.generic_all.deb

The command above will add the repository to /etc/apt/sources.list.d/ directory.

2. Install Percona Server for MySQL

Let’s consider installation of Percona Server for MySQL 8.4 and 8.0.

Install Percona Server for MySQL 8.0

Enable the repository:

$ sudo percona-release setup ps80
* Disabling all Percona Repositories
* Enabling the Percona Server for MySQL 8.0 repository
* Enabling the Percona Tools repository
Hit:1 http://repo.percona.com/prel/apt noble InRelease
Get:2 http://repo.percona.com/ps-80/apt noble InRelease [15.9 kB]                                                   
Hit:3 http://repo.percona.com/telemetry/apt noble InRelease                                                         
Get:4 http://repo.percona.com/tools/apt noble InRelease [15.8 kB]                                                   
Hit:5 http://repo.mysql.com/apt/ubuntu noble InRelease                                                              
Hit:6 http://security.ubuntu.com/ubuntu noble-security InRelease                                                    
Get:7 http://repo.percona.com/ps-80/apt noble/main Sources [2,118 B]                                                
Get:8 http://repo.percona.com/ps-80/apt noble/main amd64 Packages [15.4 kB]
Get:9 http://nova.clouds.archive.ubuntu.com/ubuntu noble InRelease [256 kB]
Get:10 http://repo.percona.com/tools/apt noble/main Sources [1,572 B]
Get:11 http://repo.percona.com/tools/apt noble/main amd64 Packages [3,212 B]   
Hit:12 http://nova.clouds.archive.ubuntu.com/ubuntu noble-updates InRelease
Hit:13 http://nova.clouds.archive.ubuntu.com/ubuntu noble-backports InRelease
Fetched 310 kB in 1s (382 kB/s)
Reading package lists... Done

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.39-30 Percona Server (GPL), Release '3', Revision 'a920dd6'
 Copyright (c) 2009-2024 Percona LLC and/or its affiliates
 Copyright (c) 2000, 2024, 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.39-30 |
+-----------+
1 row in set (0.00 sec)
 mysql> QUIT;

Install Percona Server for MySQL 8.4

Percona Server for MySQL 8.4 can be installed by running:

sudo percona-release enable-only ps-84-lts release
sudo percona-release enable tools release
sudo apt install percona-server-server

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.

3. Install Desktop Database 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:

Recommended Books:

Also read:

1 COMMENT

  1. This doesn’t work on Ubuntu 22.04. On sudo percona-release setup ps80 command you get: “Specified repository is not supported for current operating system!”.

LEAVE A REPLY

Please enter your comment!
Please enter your name here