Skip to content
Percona Software for MySQL Documentation
Rate this page
☆ ☆ ☆ ☆ ☆
Thanks for your feedback
Thank you! The feedback has been submitted.

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Use an APT repository to install Percona Server for MySQL 9.7

Percona Server for MySQL packages are available from the software repositories and from the Percona downloads page.

The Percona Software and Platform Lifecycle page lists supported platforms, products, and versions. Debian (DEB) packages support arm64 and other architectures on documented Debian and Ubuntu releases.

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.

Install Percona Server for MySQL using APT

Install Percona Server on Debian or Ubuntu with the following steps:

  1. Copy the command block in the following section. Run the commands in order.

  2. Use Configure authentication when the package manager prompts for authentication options.

  3. Open Next steps after the server packages install.

  4. Expand the Step-by-step: what each command does note for an explanation of each command.

  5. For scripted automation, see Non-interactive APT installation for Percona Server for MySQL 9.7.

Run the commands as the root user or with sudo:

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

The command sequence matches Install Percona Server for MySQL and create a database on Ubuntu. The quickstart includes steps 1 through 6. The quickstart passes --scheme https to percona-release setup and enable. The repository identifier for 9.7 is ps-97-lts.

For another Percona Server for MySQL series, run sudo percona-release list or see the MySQL software repositories reference. Percona can change published repository names when Percona adds a series.

percona-release flag: --scheme

The examples on this topic pass --scheme https. Repository URLs in APT source lists then use HTTPS. The Percona Software Repositories — percona-release reference documents the --scheme flag. Supported values are HTTP and HTTPS. Without --scheme, percona-release uses HTTP URLs by default.

You can pass --scheme https to subcommands such as setup, enable, enable-only, or disable. Use the same pattern as the examples. See the linked reference for all commands.

Percona Server for MySQL 9.7 uses the MySQL 9.x authentication model in the MySQL 9.6 documentation. Key behaviors include the following:

  • MySQL 9.x removes the mysql_native_password plugin on {{vers}}. The server has no --mysql-native-password=ON, mysql_native_password=ON, or other way to load the plugin.
  • The default_authentication_plugin system variable is unavailable in MySQL 9.x.
  • Password-based accounts use the caching_sha2_password plugin by default.
  • Applications and drivers must support caching_sha2_password.
  • TLS is optional unless a security policy or deployment mandates encrypted traffic. The caching_sha2_password plugin works without TLS for some connection types.

When the package manager prompts during installation, follow Configure authentication. Prompts depend on the package and distribution.

Step-by-step: what each command does

Each step includes a short explanation:

  1. apt update refreshes package lists for upgrades and installs. sudo runs the command with superuser privileges. The command reads sources in /etc/apt/sources.list and /etc/apt/sources.list.d/.

    sudo apt update

  2. sudo apt install -y curl installs the curl package. curl transfers data over the network. You need curl to download the Percona repository package.

    sudo apt install -y curl

  3. curl -O downloads percona-release_latest.generic_all.deb from the Percona APT repository. The -O option saves the file with the URL filename.

    curl -O https://repo.percona.com/apt/percona-release_latest.generic_all.deb

  4. The next command installs gnupg2, lsb-release, and the Percona release package. gnupg2 verifies package signatures. lsb-release reports distribution information. Together with the .deb file, these packages configure the Percona APT repository.

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

  5. percona-release setup ps-97-lts --scheme https disables current Percona repositories. The command enables release repositories for Percona Server for MySQL 9.7 over HTTPS. See the Percona Software Repositories reference. Omit --scheme https only when you need HTTP repository URLs.

    sudo percona-release setup ps-97-lts --scheme https

  6. percona-release enable ps-97-lts release --scheme https enables the Percona Server for MySQL release repository with HTTPS URLs. Run apt update next so APT loads indexes for percona-server-server and related packages.

    sudo percona-release enable ps-97-lts release --scheme https
sudo apt update

  7. Confirm repository configuration in .list files under /etc/apt/sources.list.d/. The filename, such as percona-original-release.list, depends on the percona-release version.

  8. sudo apt install -y percona-server-server installs the server package. The package manager can prompt for values such as the root password. Some builds use debconf or post-install configuration only. For password prompts and automation, see Non-interactive APT installation for Percona Server for MySQL 9.7. For authentication defaults and removed plugins, see Configure authentication.

    sudo apt install -y percona-server-server

Configure authentication

The package manager can prompt for passwords and other options during installation. Change authentication after installation when the package skips prompts. For automation, see Non-interactive APT installation for Percona Server for MySQL 9.7.

Important change in 9.7

MySQL 9.x and {{vers}} remove the mysql_native_password plugin. The default_authentication_plugin system variable is unavailable. Password-based accounts use caching_sha2_password by default. MySQL 9.x has no server-side option to re-enable native-password authentication.

For a migration from native password authentication, update accounts and clients before you deploy 9.7. See Authentication methods and Upgrade checklist for 9.7.

On 9.7, the server uses the caching_sha2_password plugin for password authentication. Client libraries and connectors must support caching_sha2_password. Use TLS when your policy requires encrypted connections. The default caching_sha2_password configuration needs no extra server settings.

See Configuring Percona repositories with percona-release for repository commands.

Percona Server for MySQL 9.7.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 installation, see Post-installation to configure and secure the server.