Disabling AUTOCOMMIT, UNIQUE_CHECKS, and FOREIGN_KEY_CHECKS speeds up mysql restores dramatically. My own tests of a 30MB dump were cut from 6 minutes to 11 seconds. My 2GB backups can now be imported in a reasonable 40 minutes. The following script will add one line to the top and bottom of your mysqldump file. This can take a while for large files. There’s no shortcut…
Tag: Bash
Simple Duplicity S3 Script
Duplicity is a command line tool that performs encrypted incremental backups. It supports a variety of file locations, including Amazon S3, and comes pre-installed on several Linux distributions. Ubuntu’s backup application, Deja Dup, is a frontend for Duplicity that adds some convenient right-click functionality to the file explorer. This works well on the home directory to quickly restore previous versions…
Jenkins Automation
Continuous integration and automated testing are essential to our internal operations, but two seemingly simple Jenkin’s features have evolved to be more important than we imagined – shell scripts and scheduled jobs. They were glossed over from the beginning, we were in this for the CI after all. Run bash scripts? Yeah, why not. Replace cron jobs? OK, but cron’s…
Matt Williamson 