Tag: mariadb

MariaDB TLS and Troubleshooting on AlmaLinux 10: SSL Connections, Certificates and Common Errors

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

Backup MySQL on Linux

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

Performing a MySQL Upgrade

Run mysql_upgrade after every MySQL version upgrade so tables stay optimized and backups keep working.

Read More

Convert MySQL Slave to Master

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