Install Percona XtraDB Cluster (PXC) on Debian 12

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
per...

Install Percona XtraDB Cluster (PXC) on Gentoo Linux

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

# PXC is primarily packaged for RHEL/Debian.
# On Gentoo Linux, use Percona's binary tarball:
# https://www.percona.com/downloads/Percona-Xtra...

Install Percona XtraDB Cluster (PXC) on NetBSD 10

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

# PXC is primarily packaged for RHEL/Debian.
# On NetBSD 10, use Percona's binary tarball:
# https://www.percona.com/downloads/Percona-XtraDB-Clu...

Install Percona XtraDB Cluster (PXC) on OpenBSD 7.5

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

# PXC is primarily packaged for RHEL/Debian.
# On OpenBSD 7.5, use Percona's binary tarball:
# https://www.percona.com/downloads/Percona-XtraDB...

Install Percona XtraDB Cluster (PXC) on RHEL 9

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

dnf install -y https://repo.percona.com/yum/percona-release-latest.noarch.rpm
percona-release enable-only pxc-80 release
dnf install -y percona-xtra...

Install Percona XtraDB Cluster (PXC) on Ubuntu 24.04

PXC provides synchronous multi-master MySQL replication using the Galera library.

Step 1 – Install

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb...

Install PHP-FPM on AlmaLinux 9

Step 1 – Install

dnf install epel-release -y
dnf install -y php php-fpm php-cli php-opcache php-mysqlnd php-mbstring php-xml php-gd
systemctl enable --now php-fpm

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/null || php-fpm8.2 -v...

Install PHP-FPM on Arch Linux

Step 1 – Install

pacman -S --noconfirm php php-fpm
systemctl enable --now php-fpm

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/null || php-fpm8.2 -v

Step 3 – Key pool settings (/etc/php/php-fpm.d/www.conf)

user  = www-data
g...

Install PHP-FPM on Debian 12

Step 1 – Install

apt update && apt upgrade -y
apt install -y php8.2-fpm php8.2-cli php8.2-opcache php8.2-mysql php8.2-mbstring php8.2-xml php8.2-gd
systemctl enable --now php8.2-fpm

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/null...

Install PHP-FPM on Gentoo Linux

Step 1 – Install

# /etc/portage/make.conf: PHP_TARGETS="php8-2"
# USE="fpm opcache mysql"
emerge --ask dev-lang/php
rc-update add php-fpm default && rc-service php-fpm start

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/null || p...

Install PHP-FPM on NetBSD 10

Step 1 – Install

pkgin install php php-fpm
echo 'php_fpm=YES' >> /etc/rc.conf && service php_fpm start

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/null || php-fpm8.2 -v

Step 3 – Key pool settings (/usr/pkg/etc/php-fpm.d/www.con...

Install PHP-FPM on OpenBSD 7.5

Step 1 – Install

pkg_add php php-fpm
rcctl enable php83_fpm && rcctl start php83_fpm

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/null || php-fpm8.2 -v

Step 3 – Key pool settings (/etc/php-fpm.conf)

user  = www-data
group =...

Install PHP-FPM on RHEL 9

Step 1 – Install

subscription-manager repos --enable codeready-builder-for-rhel-9-$(arch)-rpms
dnf install -y php php-fpm php-cli php-opcache php-mysqlnd php-mbstring php-xml php-gd
systemctl enable --now php-fpm

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null...

Install PHP-FPM on Ubuntu 24.04

Step 1 – Install

apt update && apt upgrade -y
apt install -y php8.3-fpm php8.3-cli php8.3-opcache php8.3-mysql php8.3-mbstring php8.3-xml php8.3-gd
systemctl enable --now php8.3-fpm

Step 2 – Verify

php --version
php-fpm -v 2>/dev/null || php-fpm8.3 -v 2>/dev/n...

Install PostgreSQL on AlmaLinux 9

Step 1 – Install

dnf install -y postgresql-server postgresql-contrib
postgresql-setup --initdb
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'Stro...

Install PostgreSQL on Arch Linux

Step 1 – Install

pacman -S --noconfirm postgresql
sudo -u postgres initdb --locale=en_US.UTF-8 -E UTF8 -D /var/lib/postgres/data
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE...

Install PostgreSQL on Debian 12

Step 1 – Install

apt update && apt upgrade -y
apt install -y postgresql postgresql-contrib
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongPass...

Install PostgreSQL on Gentoo Linux

Step 1 – Install

emerge --ask dev-db/postgresql
emerge --config dev-db/postgresql
rc-update add postgresql-14 default && rc-service postgresql-14 start

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER app...

Install PostgreSQL on NetBSD 10

Step 1 – Install

pkgin install postgresql16-server postgresql16-client
su -l pgsql -c 'initdb -D /usr/pkg/pgsql/data'
echo 'pgsql=YES' >> /etc/rc.conf && service postgresql start

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database an

Install PostgreSQL on OpenBSD 7.5

Step 1 – Install

pkg_add postgresql-server
su -l _postgresql -c 'initdb -D /var/postgresql/data -U postgres -A md5 -W'
rcctl enable postgresql && rcctl start postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

Install PostgreSQL on RHEL 9

Step 1 – Install

dnf install -y postgresql-server postgresql-contrib
postgresql-setup --initdb
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongPas...

Install PostgreSQL on Ubuntu 24.04

Step 1 – Install

apt update && apt upgrade -y
apt install -y postgresql postgresql-contrib
systemctl enable --now postgresql

Step 2 – Connect as superuser

sudo -u postgres psql

Step 3 – Create database and user

CREATE USER appuser WITH PASSWORD 'StrongP...

Install Prometheus on AlmaLinux 9

Step 1 – Install

VERSION=2.51.2
wget https://github.com/prometheus/prometheus/releases/download/v${VERSION}/prometheus-${VERSION}.linux-amd64.tar.gz
tar xvf prometheus-${VERSION}.linux-amd64.tar.gz
cp prometheus-${VERSION}.linux-amd64/prometheus /usr/local/bin/...

Install Prometheus on Arch Linux

Step 1 – Install

pacman -S --noconfirm prometheus

Step 2 – Create user and directories

useradd -r -s /sbin/nologin prometheus 2>/dev/null || useradd -r -s /usr/sbin/nologin prometheus
mkdir -p /etc/prometheus /var/lib/prometheus
chown prometheus:prometheus /e...