Digital Ocean Backup - Wordpress

March 3, 2015 2.1k views
WordPress Backups Server Optimization Ubuntu

I was reading the article about Droplet backups and I was wondering how this backup would effect the performance of a Wordpress site? Also if something did happen to the site or server and we had to use the backup to setup a new server how long does that normally take?

I am going to be setting up a NGINX, PHP, MySQL & Postfix service stack for a small ($5) server. I will have Wordpress running with w3tc. I have stress tested the server and have no issues with high traffic.

1 Answer

You may see slightly decreased I/O speeds while the backup process runs once per week. Aside from this there should be no effect on your running services. Your backup images are stored on your account and you can easily use them to rebuild an existing droplet (or convert them to snapshot images to spin up new droplets). The time to restore a backup should not be any different from deploying or rebuilding a droplet.

If you do plan to see a decent amount of traffic to your wordpress site I would also recommend setting up a cron job to run mysqldump to create a backup of your database at regular intervals within your filesystem. If a lot of changes occur on your database while the backup process is running it is possible for there to be corruption so this provides an easy method to ensure you have a .sql file backup of your data.

  • If I was to notice that the backup took up a lot of resources and decided to take an alternative route, is there an easy way to turn off the Droplet backup?

    You mentioned corruptions with the MySQL data but do you mean in the backup itself or just in general?

  • Yes. You can disable backups from the control panel. Click on your droplet and then on backups and you will see the option to disable them.

    The potential database corruption I was referring to was with the backup. Since the backup process runs on your droplet while it is powered on there is a potential for issues if a large number of changes occur to your database while the backup is being made. This only usually affects droplets doing a large number of SQL queries during the backup process and MySQL's built in recovery usually is able to deal with them but it is important to note.

Have another answer? Share your knowledge.