Jump to content

How do you backup your database - regularly?


Recommended Posts


rackspace has a script that does that for you. You don't need to worry about anything




I don't host with them and I have no plans to do so. I have my 3 machines with space of 1TB on each and i m only using less then 50GB.

What i am doing right now is set up cron job to dump DB every night and every week I download it manually which is taking long time since DB has reached 800Mb. Server to server will be much faster and i don't have incremental back ups so i need to fix that too.
Link to comment
Share on other sites


I don't host with them and I have no plans to do so. I have my 3 machines with space of 1TB on each and i m only using less then 50GB.



What i am doing right now is set up cron job to dump DB every night and every week I download it manually which is taking long time since DB has reached 800Mb. Server to server will be much faster and i don't have incremental back ups so i need to fix that too.




you don't need to be hosted with them. All you need is to upload their script to your server and then install the server management software on your desktop computer. After that you can control what, where, when and how often to backup from your desktop :)
Link to comment
Share on other sites


you don't need to be hosted with them. All you need is to upload their script to your server and then install the server management software on your desktop computer. After that you can control what, where, when and how often to backup from your desktop :smile:




oops! My bad I understood it wrong. Thanks! Will try it tonight
Link to comment
Share on other sites

  • 6 months later...

I have a custom script run via cron to backup to amazon s3 every day. It saves multiple copies from daily~monthly for the database.
For the files, I'm running a custom CDN which naturally makes like quadruple clones of everything at near real time with write only, no deletes except updates via mix of rsync and nginx proxy. So I find little need make additional backups. Besides, it's the db that's important. ^^

Link to comment
Share on other sites

Yeah S3 prices have come down a bit, interested to know how much you guys are paying for it.

i.e. with webbycart.com i'm paying US$8.3/month for 100GB backup space and get full ssh/ftp/sftp/scp/rsync/web gui access to backups

Link to comment
Share on other sites


what im afraid of is BW/space usage....


p4guru, you get that price and how much rasources do you use daily or monthly




~60+ GB/month in backups from 7 servers.. i wrote a clean up script which retains 10-14 days worth of backups, anything older than 10-14 days gets automatically removed via cron job setup via ssh on webbycart's backup server :smile:
Link to comment
Share on other sites


sorry for the OT how much do you pay for s3?



I actually pay $0. lol!!

s3 has a promo (this promo has been avl for a long long time now) where you get 1 full year of free s3 if you use less than 5GB of data for storage. My database alone with number of iterations I have, compressed is a little shy of 5GB.
Bandwidth usage is always just backup file being uploaded and incoming bandwidth is always free for any amount. So, 0 there again.
I've downloaded a few times, but my download costs never managed to reach 1 cent. So, 0 there again.

So, I haven't paid anything for it. I use their other services though, so I pay them something, just not for s3. If you use more than 5GB, you'd be only charged for above 5GB.

For small things, s3 is definitely the most affordable backup method. But their prices increase nearly arithmetically. So, if it's large, it becomes no longer cost efficient.

If you're looking for very affordable and large backup source, there's Kimsufi. 15 euro for a 1TB disk dedi server. Cheapest storage space avl out there.
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...