Install Let's Encrypt SSL with Certbot (Apache) on Arch Linux

Step 1 – Install

pacman -S --noconfirm certbot certbot-apache

Step 2 – Obtain and install

certbot --apache -d example.com -d www.example.com

Step 3 – Verify

apachectl configtest && systemctl reload apache2
curl -I https://exam...

Install Let's Encrypt SSL with Certbot (Nginx) on Arch Linux

Step 1 – Install Certbot + Nginx plugin

pacman -S --noconfirm certbot certbot-nginx

Step 2 – Obtain certificate

certbot --nginx -d example.com -d www.example.com

Certbot modifies Nginx config and optionally redirects HTTP to HTTP...

Install MariaDB on Arch Linux

Step 1 – Install and secure

pacman -S --noconfirm mariadb
mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl enable --now mariadb
mysql_secure_installation

Step 2 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8m...

Install Memcached on Arch Linux

Step 1 – Install

pacman -S --noconfirm memcached
systemctl enable --now memcached

Step 2 – Configure (/etc/memcached.conf)

-l 127.0.0.1   # listen on localhost only
-m 256         # memory (MB)
-c 1024        # max connections
-t 4           # threads

Step

Install ModSecurity WAF on Apache – Arch Linux

Step 1 – Install

pacman -S --noconfirm mod_security
systemctl restart httpd

Step 2 – Enable detection mode

cp /etc/modsecurity/modsecurity.conf-recommended /etc/modsecurity/modsecurity.conf 2>/dev/null || \
   cp /usr/share/doc/libapache2-mod-se...

Install MySQL on Arch Linux

Step 1 – Install and secure

pacman -S --noconfirm mysql
mysqld --initialize --user=mysql
systemctl enable --now mysqld
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8mb4 COL...

Install Nginx on Arch Linux

Step 1 – Update

pacman -Syu --noconfirm

Step 2 – Install

pacman -S --noconfirm nginx

Step 3 – Enable and start

systemctl enable --now nginx

Step 4 – Firewall

ufw allow 80/tcp && ufw allow 443/tcp && ufw reload

Step 5 – Verify

nginx -v && curl -I http:/...

Install Node.js on Arch Linux

Step 1 – Install

pacman -S --noconfirm nodejs npm

Step 2 – Verify

node --version && npm --version

Step 3 – Simple HTTP server

// app.js
const http = require('http');
http.createServer((req, res) => {
  res.writeHead(200, {'Content-Type': 'text/plain'});
  re...

Install Percona XtraDB Cluster (PXC) on Arch Linux

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

Step 1 – Install

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

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 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 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...

Install Redis on Arch Linux

Step 1 – Install

pacman -S --noconfirm redis
systemctl enable --now redis

Step 2 – Verify

redis-cli ping   # PONG

Step 3 – Bind and password (/etc/redis/redis.conf)

bind 127.0.0.1 ::1
requirepass StrongRedisPass!

Restart, then:

redis-cli -a StrongRedisPa...

Install Varnish Cache on Arch Linux

Step 1 – Install

pacman -S --noconfirm varnish
systemctl enable --now varnish

Step 2 – Basic /etc/varnish/default.vcl

vcl 4.1;

backend default {
    .host = "127.0.0.1";
    .port = "8080";
    .connect_timeout = 5s;
    .first_byte_timeout = 90s;
}

sub...

Install WordPress on Arch Linux (Nginx + PHP-FPM + MySQL)

Prerequisites

• Nginx · PHP-FPM · MySQL

Step 1 – Database

CREATE DATABASE wordpress CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'wpuser'@'localhost' IDENTIFIED BY 'WPStrongPass!';
GRANT ALL PRIVILEGES ON wordpr...

Integrate PHP-FPM with Nginx on Arch Linux

Prerequisites

PHP-FPM installed and running. See PHP-FPM install guide.

Socket path: /run/php-fpm/php-fpm.sock

Step 1 – Nginx server block

server {
    listen 80;
    server_name example.com;
    root /var/www/example.com/html;
    index index....

MariaDB Backup and Restore on Arch Linux

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mariab

MariaDB Galera Cluster on Arch Linux

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

# Install mariadb-galera for Arch Linux

Step 2 – Configure Node 1 (/etc/mysql/conf.d/galera.cnf)

[mysqld]
binlog_format            = ROW
default-storage-engine...

Memcached Distributed Setup on Arch Linux

Memcached itself has no cluster mode — distribution is handled by the client using consistent hashing.

Run multiple instances

memcached -d -l 192.168.1.10 -p 11211 -m 512 -t 4 -u memcache
memcached -d -l 192.168.1.11 -p 11211 -m 512 -t 4 -u memcache

s

Monitor Percona XtraDB Cluster on Arch Linux

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

MySQL Backup and Restore on Arch Linux

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz

MySQL Primary-Replica Replication on Arch Linux

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH m...

Nginx Load Balancing on Arch Linux

Round-robin (default)

upstream myapp {
    server 192.168.1.10:8080;
    server 192.168.1.11:8080;
    server 192.168.1.12:8080;
}
server {
    listen 80;
    server_name lb.example.com;
    location / { proxy_pass http://myapp; }
}

Least connections

upstre...

Nginx Rate Limiting on Arch Linux

Define zones in http block

http {
    limit_req_zone $binary_remote_addr zone=api:10m     rate=10r/s;
    limit_req_zone $binary_remote_addr zone=login:10m   rate=5r/m;
}

Apply to locations

location /api/ {
    limit_req zone=api burst=20 nodelay;
    limi...