Optional steps after repository install for Percona Server for MySQL 9.7¶

After you install Percona Server for MySQL from a repository, you can enable the testing repository or install Percona Toolkit user-defined functions (UDFs).

Install Percona Toolkit UDFs (optional)¶

User-defined functions (UDFs) add custom functions to MySQL. Percona Server for MySQL includes UDFs from Percona Toolkit for data integrity checks and performance monitoring. The UDFs speed up checksum calculations:

Function	Description
`fnv_64`	Fast 64-bit hash function
`fnv1a_64`	Variant of `fnv_64` with improved distribution
`murmur_hash`	Fast non-cryptographic hash function

Install Percona Toolkit UDFs after Percona Server packages are installed:

INSTALL COMPONENT 'file://component_percona_udf';

Expected output

Query OK, 0 rows affected (0.01 sec)

You can use the UDFs in SQL queries. Example: SELECT fnv_64('test_string');

For UDF details, see Percona Toolkit UDF functions.

Install the Percona testing repository¶

Do not use testing repository builds in production. Testing builds are pre-release versions. They can contain bugs or incomplete features.

Percona offers pre-release builds from the testing repository for advanced users who want to:

Evaluate upcoming improvements
Provide feedback on development versions
Test features before the official release

The testing repository has the following limitations:

Features can change without notice
Percona does not provide production support for testing builds
The repository can contain experimental or incomplete functionality
The repository can exclude features from the final release

APT¶

Enable the testing repository:

sudo percona-release enable ps-97-lts testing --scheme https

Disable the testing repository and return to stable releases:

sudo percona-release disable testing
sudo apt update

DNF¶

Enable the testing repository:

sudo percona-release enable ps-97-lts testing

Expected output

* Enabling Percona Server for MySQL 9.7 testing repository
* Running dnf update...
Last metadata expiration check: 0:01:23 ago on Mon Jan 15 10:30:00 2024.
All packages are up to date.

Disable the testing repository and return to stable releases:

sudo percona-release disable testing
sudo dnf update

Expected output

* Disabling Percona testing repository
* Running dnf update...
Last metadata expiration check: 0:01:23 ago on Mon Jan 15 10:30:00 2024.
All packages are up to date.