• MariaDB
• Server
• Realm of Espionage

• openSUSE Tumbleweed (Server)

• Settings being done before installation is intentional

sudo mkdir -p '/etc/my.cnf.d' && sudo -e '/etc/my.cnf.d/custom.cnf'

[client]
default-character-set = 'utf8mb4'

[mariadb-client]
default-character-set = 'utf8mb4'

[mariadbd]
character-set-client-handshake = 'FALSE'
character-set-server = 'utf8mb4'
collation-server = 'utf8mb4_unicode_ci'
init-connect='SET NAMES utf8mb4'
expire_logs_days = '7'
max_binlog_size = '100M'
skip-networking = 'On'
table_definition_cache = '1400'

# End

sudo zypper install 'mariadb'

sudo systemctl enable 'mariadb' --now && sudo mariadb-secure-installation

sudo mariadb-check --optimize --all-databases --force --extended --auto-repair

sudo mariadb

CREATE USER 'maintenance'@'localhost' IDENTIFIED BY 'x';

GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost';

FLUSH PRIVILEGES;EXIT;

sudo mkdir -p '/var/lib/mysql/auth' && sudo -e '/var/lib/mysql/auth/maintenance' && sudo chown 'mysql':'mysql' '/var/lib/mysql/auth/maintenance' && sudo chmod '0600' '/var/lib/mysql/auth/maintenance'

[mariadb-check]
user=maintenance
password=x

# End

sudo -e '/etc/systemd/system/db-m.service'

[Service]
User=mysql
Group=mysql
Type=oneshot

ExecStart='/usr/bin/mariadb-check' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --optimize --all-databases --force --extended --auto-repair

ExecStartPost='/usr/bin/sync'

# End

• Weekly

sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now

[Unit]
Description=MariaDB Database Check, Repair, and Optimization
After=mariadb.service

[Timer]
OnCalendar=weekly
Persistent=true

[Install]
WantedBy=timers.target

# End

sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l

sudo mariadb-admin variables | egrep 'utf8|networking|socket'

select User,Host from mysql.user;

/run/mysql/mysql.sock

• Uses an auth file; can use mariadb with user/pass flags instead of sudo

sudo mariadb-dump --defaults-extra-file='/var/lib/mysql/auth/piwigo' --single-transaction 'piwigo' -r ~/'piwigo-database-manual-'$(date +%Y-%m-%d)'.sql'