Use an APT repository to install Percona Server for MySQL 8.4¶

Ready-to-use packages are available from the Percona Server for MySQL software repositories and the Percona downloads page.

Specific information on the supported platforms, products, and versions is described in Percona Software and Platform Lifecycle .

The percona-release tool is a command-line utility that simplifies the management and installation of Percona software packages, providing access to the latest versions and ensuring consistency across environments. For more information, refer to the Percona Software Repositories Documentation.

We gather Telemetry data in the Percona packages and Docker images.

Review Get help from Percona for ways that we can work with you.

Version changes¶

Percona supports DEB builds with ARM packages with the arm64.deb extension on supported Debian and Ubuntu releases.

Unattended installations¶

The -y flag automatically confirms all actions without asking for user input. This makes running commands smoother, especially in situations where you can’t or don’t want to interact, like during unattended installations or automated scripts. However, keep in mind that using the -y flag skips confirmation prompts, which means you won’t have a chance to review any changes before they’re made. So, it’s best to use this flag only when you’re sure about the command you’re executing.

The recommended syntax for using this flag with the percona-release setup is:

$ percona-release setup -y ps-84-lts

Install Percona Server for MySQL using APT¶

Run the following commands as a root user or with sudo:

sudo apt update
sudo apt install curl
curl -O https://repo.percona.com/apt/percona-release_latest.generic_all.deb
sudo apt install gnupg2 lsb-release ./percona-release_latest.generic_all.deb
sudo apt update
sudo percona-release enable-only ps-84-lts release
sudo apt install percona-server-server

In MySQL 8.4, the mysql_native_password plugin is no longer loaded by default. When the package manager prompts you during installation, you must follow the choices and steps in Configure authentication. If you choose legacy authentication but do not enable the plugin in configuration, clients may be unable to connect or the service may fail to start.

The following sections provide detailed explanations for each step:

This command updates the package lists for upgrades and new package installations. sudo runs the command with superuser privileges; apt update resynchronizes the package index files from the sources in your system’s sources.list.
```
sudo apt update
```
This command installs the curl package. curl is a command-line tool used to transfer data over networks and is required to download the Percona repository package.
```
sudo apt install curl
```
This command downloads the percona-release_latest.generic_all.deb file from the Percona APT repository. The -O option saves the file with the same name as in the URL.
```
curl -O https://repo.percona.com/apt/percona-release_latest.generic_all.deb
```
This command installs gnupg2 (for package signature verification), lsb-release (for distribution information), and the downloaded Percona release package. Together they configure the Percona APT repository on your system.
```
sudo apt install gnupg2 lsb-release ./percona-release_latest.generic_all.deb
```
This command refreshes the package lists so the system recognizes the newly enabled Percona repository and the latest package versions.
```
sudo apt update
```
This command enables the Percona Server for MySQL 8.4 release repository. It configures apt to install packages from the Percona repository.
```
sudo percona-release enable-only ps-84-lts release
```
You can verify the repository setup by checking the Percona release list in /etc/apt/sources.list.d/percona-original-release.list.
This command installs the percona-server-server package. During installation, the package manager will prompt you to select the default authentication plugin; follow the Configure authentication section below.
```
sudo apt install percona-server-server
```

Configure authentication¶

During the installation process, the package manager will prompt you to select the default authentication plugin.

Important Change in MySQL 8.4

Percona Server for MySQL 8.4 inherits the upstream change where the mysql_native_password plugin is disabled by default.

Option 1: Recommended (Strong Password Encryption)Option 2: Legacy (Native Password)

Select this option if you are setting up a new server or using modern application drivers.

This uses the caching_sha2_password plugin, providing superior security and performance. No further configuration is required.

Select this option only if you must support legacy applications that cannot be updated.

If you choose this option, you must manually enable the plugin after installation, or the server will fail to authenticate users using this method.

Open your configuration file (e.g., /etc/mysql/mysql.conf.d/mysqld.cnf).
Add the following to the [mysqld] section:
```
[mysqld]
mysql-native-password=ON
```
Restart the service:
```
sudo systemctl restart mysql
```

See Configuring Percona repositories with percona-release for more information.

Percona Server for MySQL 8.4.x comes with the MyRocks storage engine. This storage engine is installed as a plugin. For information on installing and configuring MyRocks, refer to the Percona MyRocks Installation Guide.

Next Steps¶

After successful installation, see Post-installation for detailed steps to configure and secure your Percona Server for MySQL installation.

Install Percona Toolkit UDFs (Optional)¶

Percona Server for MySQL includes user-defined functions (UDFs) from Percona Toolkit . These UDFs provide faster checksum calculations:

fnv_64: Fast hash function
fnv1a_64: Alternative fast hash function
murmur_hash: High-performance hash function

User-Defined Functions (UDFs) are custom functions you can add to MySQL to extend its capabilities. These particular UDFs are useful for data integrity checks and performance monitoring.

To install these functions after installation:

INSTALL COMPONENT 'file://component_percona_udf';

Expected output

Query OK, 0 rows affected (0.01 sec)

You can now use these functions in your SQL queries. For example: SELECT fnv_64('test_string');

For detailed information about these functions, see Percona Toolkit UDF functions.

Install the Percona testing repository using APT¶

Percona offers pre-release builds from the testing repository. As a superuser, run percona-release with the testing argument to enable it:

sudo percona-release enable ps-84-lts testing

Do not run testing repository builds in production. The build may not contain all the features available in the final release and may change without notice.