MariaDB Backup and Restore on NetBSD 10

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

Mariaba

MariaDB Backup and Restore on OpenBSD 7.5

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

Maria

MariaDB Backup and Restore on RHEL 9

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

Mariabacku

MariaDB Backup and Restore on Ubuntu 24.04

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

Mari

MariaDB Galera Cluster on AlmaLinux 9

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

dnf install -y mariadb-server-galera galera

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

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

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

MariaDB Galera Cluster on Debian 12

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

apt install -y galera-4 mariadb-server

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

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

MariaDB Galera Cluster on Gentoo 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 Gentoo Linux

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

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

MariaDB Galera Cluster on NetBSD 10

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

# Install mariadb-galera for NetBSD 10

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

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

MariaDB Galera Cluster on OpenBSD 7.5

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

# Install mariadb-galera for OpenBSD 7.5

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

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

MariaDB Galera Cluster on RHEL 9

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

dnf install -y mariadb-server-galera galera

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

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

MariaDB Galera Cluster on Ubuntu 24.04

Nodes: 192.168.1.10 · 192.168.1.11 · 192.168.1.12

Step 1 – Install Galera on all nodes

apt install -y galera-4 mariadb-server

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

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

Update your system:

sudo yum update

Install and Start MariaDB

sudo yum install mariadb-server

Enable MariaDB to start on boot and then start the service:

sudo systemctl enable mariadb

sudo systemctl start mariadb

MariaDB will bind to localhost (127.0.0.1) by default. For informat...

Install packages on both nodes

sudo dnf --enablerepo=ha -y install pacemaker pcs corosync

sudo dnf -y install https://downloads.mariadb.com/MaxScale/latest/centos/8/x86_64/maxscale-22.08.3-1.rhel.8.x86_64.rpm

Note about maxscale rpm package. If you get 404 then there is most likely new ver...

Install packages on both nodes

sudo yum install corosync pcs pacemaker maxscale

Set the password for the hacluster user [both nodes]

sudo passwd hacluster

Start the pcs daemon service [both nodes]

sudo systemctl start pcsd

Authenticate the cluster

sudo pcs cluster auth node01.domain....

Introduction

In this guide, we will be setting up the latest version of MediaWiki on an Ubuntu server. We will use the lighttpd web server to make the actual content available, php-fpm to handle dynamic processing, and mysql to store our wiki's data.

This guide walks you through installin...

Install Memcached and set up distributed caching with consistent hashing across multiple nodes.

Memcached Distributed Setup on AlmaLinux 9

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

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

Memcached Distributed Setup on Debian 12

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

Memcached Distributed Setup on Gentoo 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

Memcached Distributed Setup on NetBSD 10

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

Memcached Distributed Setup on OpenBSD 7.5

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

Memcached Distributed Setup on RHEL 9

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

syst