Memcached Distributed Setup on Ubuntu 24.04

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

Monitor Percona XtraDB Cluster on AlmaLinux 9

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on Arch Linux

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on Debian 12

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on Gentoo Linux

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on NetBSD 10

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on OpenBSD 7.5

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on RHEL 9

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

Monitor Percona XtraDB Cluster on Ubuntu 24.04

Key wsrep variables

SHOW STATUS LIKE 'wsrep_%';

curl -sSf --max-time 120 'https://websitetomonitor.url' --compressed || echo "do something with alarm on failure"

-s means silent -S show error -f Fail silently (no output at all) on server errors --max-time maximum time allowed for request

Cronjob every 2 minutes

*/2 * * * * /usr/local/bin/ch...

Deploy Prometheus and Grafana to collect metrics and visualise dashboards for all your services.

Install MySQL, configure primary-replica replication, automate backups and harden security.

Mysql 8 has different method resetting pw then mysql 5. First is needed to set empty auth string

In Linux:

Stop mysqld

service mysqld stop

Start MySQL with skip grant tables

mysqld --skip-grant-tables --skip-networking --user=mysql &

Set authentication empty string

login

mysql -u ro...

MySQL Backup and Restore on AlmaLinux 9

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 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 Backup and Restore on Debian 12

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 Backup and Restore on Gentoo 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.g...

MySQL Backup and Restore on NetBSD 10

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 Backup and Restore on OpenBSD 7.5

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 Backup and Restore on RHEL 9

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

Re

MySQL Backup and Restore on Ubuntu 24.04

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

MySQL Primary-Replica Replication on AlmaLinux 9

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

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

MySQL Primary-Replica Replication on Debian 12

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