mysqldump vs mysqlpump vs mydumper: the backup that keeps you up at night
MySQL backup tools compared: mysqldump vs mydumper vs mysqlpump on a 60 GB database. Real dump and restore times, parallelism and architectural choice.
Mariadb
4 tagged articles
MySQL
MySQL
Binary logs in MySQL: what they are, how to manage them, and when you can delete them
MySQL binary log: management, retention and point-in-time recovery. Real case of a server with disk at 95% and 180 GB of binlogs in six months.
MySQL
Galera Cluster with 3 nodes: how I solved a MySQL availability issue
3-node MySQL Galera Cluster for high availability: synchronous replication, quorum, SST/IST. Full configuration against single point of failure.
MySQL
MySQL Users: Why 'mario' and 'mario'@'localhost' Are Not the Same Person
MySQL users and hosts: 'mario' and 'mario'@'localhost' are different entities. MySQL/MariaDB authentication model, common mistakes and correct GRANTs.