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
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
November 8, 2026 · Zwiegnet Consulting
Enable SSL/TLS in PostgreSQL 18 on AlmaLinux 10 with a private CA, enforce hostssl and verify-full, add client certificates, then pool connections with PgBouncer using SCRAM auth_query and TLS.
Read More
November 7, 2026 · Zwiegnet Consulting
PostgreSQL on AlmaLinux series, part 6. Previous: part 5, PostgreSQL Performance Tuning on AlmaLinux 10: postgresql.conf, EXPLAIN ANALYZE, Indexes and Autovacuum. Next: part 7, PostgreSQL SSL/TLS and PgBouncer Connection Pooling…
Read More
November 2, 2026 · Zwiegnet Consulting
Tune PostgreSQL 18 on AlmaLinux 10: size shared_buffers, work_mem and WAL settings, enable pg_stat_statements, read EXPLAIN ANALYZE plans, add the right indexes and keep autovacuum ahead of the workload.
Read More