Ubuntu

sudo apt-get update -yqq
sudo apt-get install -yqq p7zip-full

Fedora or CentOS / RHEL

CentOS 7.x Download and install manually

wget https://www.mirrorservice.org/sites/dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/p7zip-16.02-10.el7.x86_64.rpm
wget https://www.mirrorservice.org/s...

1. Delete all existing rules

iptables -F

2. Set default chain policies

iptables -P INPUT DROP

iptables -P FORWARD DROP

iptables -P OUTPUT DROP

3. Block a specific ip-address

BLOCK_THIS_IP="x.x.x.x"

iptables -A INPUT -s "$BLOCK_THIS_IP" -j DROP

4. Allow ALL incoming SSH

iptables -...

Add a Node to Percona XtraDB Cluster on AlmaLinux 9

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/my.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on             = ON
wsrep_provid...

Add a Node to Percona XtraDB Cluster on Arch Linux

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/mysql/mysql.conf.d/mysqld.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on...

Add a Node to Percona XtraDB Cluster on Debian 12

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/mysql/mysql.conf.d/mysqld.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on...

Add a Node to Percona XtraDB Cluster on Gentoo Linux

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/mysql/mysql.conf.d/mysqld.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on...

Add a Node to Percona XtraDB Cluster on NetBSD 10

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/mysql/mysql.conf.d/mysqld.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on...

Add a Node to Percona XtraDB Cluster on OpenBSD 7.5

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/mysql/mysql.conf.d/mysqld.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on...

Add a Node to Percona XtraDB Cluster on RHEL 9

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/my.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on             = ON
wsrep_provider...

Add a Node to Percona XtraDB Cluster on Ubuntu 24.04

Prerequisites

• Cluster bootstrapped and running
• PXC installed on this node
• Ports 3306, 4444, 4567, 4568 open

Configure this node (/etc/mysql/mysql.conf.d/mysqld.cnf, example Node 2)

[mysqld]
server-id            = 2
wsrep_on...

Apache .htaccess and mod_rewrite on AlmaLinux 9

Enable mod_rewrite

# mod_rewrite is loaded by default in /etc/httpd/conf.modules.d/00-base.conf

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .htaccess

Apache .htaccess and mod_rewrite on Arch Linux

Enable mod_rewrite

# Uncomment LoadModule rewrite_module in /etc/httpd/conf/httpd.conf
systemctl restart httpd

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Com

Apache .htaccess and mod_rewrite on Debian 12

Enable mod_rewrite

a2enmod rewrite && systemctl restart apache2

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .htaccess recipes

Force HTTPS

RewriteEng...

Apache .htaccess and mod_rewrite on Gentoo Linux

Enable mod_rewrite

# Add 'rewrite' to APACHE2_MODULES in /etc/conf.d/apache2
rc-service apache2 restart

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .

Apache .htaccess and mod_rewrite on NetBSD 10

Enable mod_rewrite

# Enable mod_rewrite in httpd.conf

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .htaccess recipes

Force HTTPS

RewriteEngine On
Rew...

Apache .htaccess and mod_rewrite on OpenBSD 7.5

Enable mod_rewrite

# Enable mod_rewrite in httpd.conf

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .htaccess recipes

Force HTTPS

RewriteEngine On
R...

Apache .htaccess and mod_rewrite on RHEL 9

Enable mod_rewrite

# mod_rewrite is loaded by default in /etc/httpd/conf.modules.d/00-base.conf

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .htaccess recip

Apache .htaccess and mod_rewrite on Ubuntu 24.04

Enable mod_rewrite

a2enmod rewrite && systemctl restart apache2

Allow overrides in virtual host

    AllowOverride All
    Require all granted

Common .htaccess recipes

Force HTTPS

Rewrite...

Apache + PHP-FPM on AlmaLinux 9

Step 1 – Enable proxy modules

dnf install -y php php-fpm
systemctl enable --now php-fpm

Step 2 – Virtual host with PHP-FPM handler

    ServerName example.com
    DocumentRoot /var/www/example.com/html
    
        SetHandl...

Apache + PHP-FPM on Arch Linux

Step 1 – Enable proxy modules

systemctl enable --now php-fpm && systemctl reload httpd

Step 2 – Virtual host with PHP-FPM handler

    ServerName example.com
    DocumentRoot /var/www/example.com/html
    
        SetHandler...

Apache + PHP-FPM on Debian 12

Step 1 – Enable proxy modules

a2enmod proxy_fcgi setenvif
a2enconf php8.2-fpm
systemctl reload apache2

Step 2 – Virtual host with PHP-FPM handler

    ServerName example.com
    DocumentRoot /var/www/example.com/html
    ...

Apache + PHP-FPM on Gentoo Linux

Step 1 – Enable proxy modules

rc-service php-fpm start && rc-service apache2 reload

Step 2 – Virtual host with PHP-FPM handler

    ServerName example.com
    DocumentRoot /var/www/example.com/html
    
        SetHandler...

Apache + PHP-FPM on NetBSD 10

Step 1 – Enable proxy modules

service php-fpm start && service apache reload

Step 2 – Virtual host with PHP-FPM handler

    ServerName example.com
    DocumentRoot /var/www/example.com/html
    
        SetHandler "proxy:uni...

Apache + PHP-FPM on OpenBSD 7.5

Step 1 – Enable proxy modules

rcctl enable php83_fpm && rcctl start php83_fpm && rcctl reload apache2

Step 2 – Virtual host with PHP-FPM handler

    ServerName example.com
    DocumentRoot /var/www/example.com/html
    ...