visit our site

Mysqldump Through a HTTP Request with Golang

In Blog, Golang

by Andrei Grijincu on September 4, 2017

So, in a previous post I explained how one can backup all databases on a server, each in its own dump file. Let’s take it to the next level and make a Golang program that will let us run the dump process with a HTTP request.

Assuming you already have Go installed on the backup server, create first a project directory in your home folder for example. Copy the mysql dump script from here and save it as in your project folder. Modify ROOTDIR="/backup/mysql/" inside to reflect current project directory.

We will create a Golang script with two functions. One will launch the backup script when a specific HTTP request is done. The other one will put the HTTP call behind a authentication, so only people with credentials will be able to make the backup request.

This uses DB_BACKUP_USER and DB_BACKUP_PASSWORD that you will have to set as environment variables. Just append this to your ~/.bashrc file

Now run source ~/.bashrc to load them.

Build the executable with go build http-db-backup.go where http-db-backup.go is the name of your Go file. Now you need to run the executable with sudo, but while preserving the environment: sudo -E ./http-db-backup

Now if you open your browser and open http://111.222.333.444:8080/backup (where 111.222.333.444 is your backup machine IP) the backup process will start, and you will get the output of the in your browser when backup finishes.

We can furthermore add another function to list the directory in browser, so you can download the needed backup or backups.

All you need to do is to add http.HandleFunc("/", lister) to your main() and navigate to http://111.222.333.444:8080/ . You will be able to navigate the backup directory to download the dump files.

Leave a Reply

Your email address will not be published. Required fields are marked *