Author Topic: Customer Self-Backups and Richweb Backups  (Read 834 times)

0 Members and 1 Guest are viewing this topic.

Offline Doug Hazard

  • Richweb Staff (Admin)
  • *
  • Posts: 28
  • Gender: Male
  • CFB / MBB Junkie
    • http://twocentsradio.net
Customer Self-Backups and Richweb Backups
« on: December 05, 2016, 11:09:35 am »
Believe it or not, this actually goes hand in hand with the "Richweb / Globalweb Hosting and MySQL Database Backups" post I've made.

We already backup the databases each nite, on the database cluster, using a full mysql dump.

Quote
root@db1 10:49:39 > /data/BACKUP/db # find ./ | grep vh
./[CLIENTNAME]
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-22-localhost.db.gz
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-26-localhost.db.gz
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-23-localhost.db.gz
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-24-localhost.db.gz
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-27-localhost.db.gz
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-25-localhost.db.gz
./[CLIENTNAME]/[CLIENTNAME]-MySQL-db-2016-11-28-localhost.db.gz

We already backup the filesystem too - nightly rsync off site on even days and nightly rysnc onsite on odd days.

And there are 2 historical files - full tarballs - of the site kept as well  back 45 days or so:
Quote
2016-10-20_data_gwebvs3.tar.gz  2016-11-20_data_gwebvs3.tar.gz

My problem with php web app driven backups is they:
  • Write the backups into the web files, making the backups ever larger;
  • They never get deleted;
  • Rely on wget of a url to run, which means they run from the web process, which is shoddy (error prone), timeouts, etc; and
  • They can easily be deleted or damaged accidentally or intentionally via an  ftp client mistake.
I prefer (well insist) the backups be kept on separate disks/locations etc.

Looks like you already have some backups getting cut on your own:

I think really you just backup the site before work is done (like client changes) and let our backups do the rest.

You're at 1.2G of storage now, which is not bad ... but over half of that is just backups:
Quote
du -sh /var/www/[CLIENTNAME]/backups/
755M   /var/www/[CLIENTNAME]/backups/

If [CLIENT NAME] wants an extra level of backups, you can setup a job to run once a month, and then have a script that logs in via ftp and pulls them back to your site if you want. We can create a script that pushes our backups to an ftp server of your choice too, just would take a little time to set it up.

Backups I see now:
Quote
root@vs3 10:52:18 > /var/www # find [CLIENTNAME]/backups/
[CLIENTNAME]/backups/
[CLIENTNAME]/backups/files
[CLIENTNAME]/backups/files/1480345342.zip
[CLIENTNAME]/backups/files/1475001754.zip
[CLIENTNAME]/backups/database
[CLIENTNAME]/backups/database/1477667989@@[CLIENTNAME].sql.zip
[CLIENTNAME]/backups/database/1480345326@@[CLIENTNAME].sql.zip
[CLIENTNAME]/backups/database/1475001736@@[CLIENTNAME].sql.zip

root@vs3 10:52:21 > /var/www # ls -alt [CLIENTNAME]/backups/database/1477667989@@[CLIENTNAME].sql.zip
-rw-r--r-- 1 www-data www-data 554256 Oct 28 11:20 [CLIENTNAME]/backups/database/1477667989@@[CLIENTNAME].sql.zip

root@vs3 10:52:27 > /var/www # ls -alt [CLIENTNAME]/backups/database/1480345326@@[CLIENTNAME].sql.zip
-rw-r--r-- 1 www-data www-data 556997 Nov 28 10:02 [CLIENTNAME]/backups/database/1480345326@@[CLIENTNAME].sql.zip
« Last Edit: December 05, 2016, 03:42:17 pm by Doug Hazard »
Doug "Bear" Hazard
@BearlyDoug  |  @GridironHistory  |  @Hogville | http://gridironhistory.com

Co-Host of Two Cents Radio, powered by the SportsManCave.com Radio Network, Wednesday Nights from 8 PM to 10 PM Central, covering SEC and Sun Belt Sports.

Listen at SMCRadio.com and follow @TwoCentsRadio on Twitter!

 

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name: Email:
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image
Type the letters shown in the picture:
What Southeastern Conference team lost the final BCS National Championship game to be played in College Football? (6 letters, located in the State of Alabama):