Daily MySQL database dump, back up to S3
I'm in the process of, or planning at least, ditching MySQL/WordPress/CloudFlare and moving to a static site hosted on S3/CloudFront. At the moment, as AWS Route 53 does not support S3 or CloudFront as an Alias Target, moving to S3/CloudFront means that I have to have an A record pointing to a web server somewhere, which in turn redirects the request to the actual site's CloudFront CNAME. I do have such a server (running Nginx), but the same thing could be as well achieved by using a service such as Arecord.net. This redirect means that there's no way to run a site without the www.-prefix. Which I can live with. Also, at the moment, no SSL support is available but I'm sure I can live with that too as WordPress is simply slow, and most of all a big waste of resources. Getting rid of all the dynamic parts (seriously, it's not like there are a lot of commenters around here) will make this thing run fast, at least compared to what page load times currently are. My tests show that CloudFront returns cached pages in less than 200ms.
So, I'm killing one extra server in the near future and putting these snippets here for my own possible future use.
~/.my.cnf:[client] user = usename password = password host = hostname [mysql] database = dbname<dir>/wp-db-backup.sh:
#!/bin/sh DBFILE="<dir>/dbname-`/bin/date +%s`.gz" /usr/bin/mysqldump --quick dbname | /bin/gzip -c >$DBFILE /usr/bin/s3cmd put $DBFILE s3://bucketname/ /bin/rm $DBFILEcrontab:
45 3 * * * /usr/bin/nice -n 20 <dir>/wp-db-backup.sh >/dev/null 2>&1
Categorised as: snippet