November 15, 2026 · Zwiegnet Consulting
Encrypt MariaDB 10.11 connections on AlmaLinux 10: build a private CA and SAN certificates with openssl, enable ssl_cert/ssl_key/ssl_ca, REQUIRE SSL/X509 and require_secure_transport, verify clients, encrypt Galera and SST traffic, handle HAProxy and rotate certificates with FLUSH SSL, then fix the common MariaDB errors (1045, 2002, 1040, 1205, 1213, 2013, 1146, 1047, TLS errors).
Read More
November 14, 2026 · Zwiegnet Consulting
Tune MariaDB on AlmaLinux 10: size the InnoDB buffer pool and redo log, set flush, connection and temp table limits, enable and rotate the slow query log, analyze it with mariadb-dumpslow and pt-query-digest, and fix slow queries with EXPLAIN, ANALYZE and indexes.
Read More
November 13, 2026 · Zwiegnet Consulting
Build a three-node MariaDB Galera Cluster on AlmaLinux 10: firewalld and SELinux ports, bootstrap, SST joins, verification, safe restarts, crash recovery, backups and troubleshooting.
Read More
November 12, 2026 · Zwiegnet Consulting
Set up MariaDB primary/replica replication with GTID on AlmaLinux 10: seed the replica with mariadb-backup, start replication, monitor it, switch over and fix common errors.
Read More
November 11, 2026 · Zwiegnet Consulting
Backup MySQL on Linux Backup MySQL on Linux Backing up MySQL databases on Linux can be relatively easy once you get the hang of it.. issue the following command: mysqldump…
Read More
November 11, 2026 · Zwiegnet Consulting
Back up MariaDB/MySQL on AlmaLinux 10 with mariadb-dump and mariadb-backup, automate it with a systemd timer, and restore fully, per database or to a point in time.
Read More
November 10, 2026 · Zwiegnet Consulting
Create MariaDB/MySQL admin and least-privilege application accounts, use GRANT, REVOKE and roles, and open AlmaLinux 10 to an application subnet safely.
Read More
November 9, 2026 · Zwiegnet Consulting
Install MariaDB 10.11/11.8 or MySQL 8.4 from AlmaLinux 10 AppStream, secure it with mariadb-secure-installation, apply a hardening config and verify.
Read More
October 10, 2026 · Zwiegnet Consulting
Run mysql_upgrade after every MySQL version upgrade so tables stay optimized and backups keep working.
Read More
October 6, 2026 · Zwiegnet Consulting
Convert MySQL Slave to Master Convert MySQL Slave to Master If you ever have some sort of major failure, or you are just testing your fail over capabilities, you have…
Read More