Percona 8, Docker

Create MySQL configuration and data directory:

mkdir -p ~/mysql/var/lib/mysql ~/mysql/etc/mysql/conf.d

[Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

cd ~/mysql/etc/mysql/conf.d
cat << 'EOF' > ~/mysql_native_password.cnf
[mysqld]
default_authentication_plugin=mysql_native_password
EOF

Start Percona 8

docker run --name percona8 \
--restart always \
-v $HOME/mysql/var/lib/mysql:/var/lib/mysql \
-v $HOME/mysql/etc/mysql/conf.d:/etc/my.cnf.d \
-e MYSQL_ROOT_PASSWORD="zabbix" \
-e TZ="Europe/Riga" \
-p 3306:3306 \
-d percona:ps-8.0.23-14

Or:

docker run --name percona8 \
--restart always \
--cap-add=sys_nice \
-v $HOME/mysql/var/lib/mysql:/var/lib/mysql \
-v $HOME/mysql/etc/mysql/conf.d:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD="zabbix" \
-e TZ="Europe/Riga" \
-p 3306:3306 \
-d percona:ps-8.0.23-14

CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'zabbix'@'%' IDENTIFIED BY 'zabbix'; ALTER USER 'zabbix'@'%' IDENTIFIED WITH mysql_native_password BY 'zabbix'; GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'%'; FLUSH PRIVILEGES;

xzcat schema.sql.xz data.sql.xz | mysql zabbix

Restore history
Install partitioning

Install Client 8:

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
sudo percona-release setup ps80
sudo apt install percona-server-client

Install passwordless file:

cat << 'EOF' > ~/.my.cnf
[client]
host=127.0.0.1
port=3306
user=root
password=zabbix
EOF

Repository:
https://www.percona.com/doc/percona-server/LATEST/installation/apt_repo.html