MySQL replication status monitoring

Anurag Bhatia
Background I am running my own authoritative DNS servers for the last few years. In earlier stages I just used registrar-provided DNS, later moved to “Cloud provider” provided DNS and ultimately settled for running my own auth DNS. Two major requirements pushed me to self-host auth DNS: Requirement of REST API for DNS needed by the web servers to resolve Letsencrypt certbot DNS-based challenge. This allows me to have internally hosted tools with Letsencrypt issues TLS certificates instead of self-signed ones.

Quick simple script for automated database dumps

Anurag Bhatia
I tried looking for script for database dumps but most of them are way too complex then a simple solution one can implement. Thus, I wrote a quick simple 1 page (infact few lines) bash script for database dumps. Here’s the code: #!/bin/bash #Script for MySQL automated dumps dbhost=DB-HOSTNAME-HERE dbusername=DB-USERNAME-HERE dbpassword=DB-PASSWORD-HERE # Enter database names here dbname=( database1 database2 database3 ) for i in "${dbname[@]}" do timestamp=backup_`date +%F.%T` output=$i+$timestamp mysqldump -h $dbhost -u $dbusername -p$dbpassword -C $i | bzip2 -c > /backups/MySQL-automated/$output done To use this script, simply add names of database inside brackets in front of “dbname” like