Register Members List Search Today's Posts Mark Forums Read

Mod Options
Old 04 Mar 2008, 22:24
DevilYellow DevilYellow is offline
Join Date: Nov 2004
Post MySQL Hotcopy - > S3 Backup Solution.

I know that Masalaman's Hotcopy Thread is widely popular as well extremely popular. Lately I wanted to apply an off-site backup solution to my database backups. I've been using Amazon's Simple Storage Solution (S3). As crazy as it sounds it only costs me $1.50 a month to backup 2 sites and 2 databases. One site has 3+ million posts and the over is over 15,000 posts.

So back in December I devised a way to perform regular hotcopy backups, then combined the backed up files in an archive, then moved the archive off to S3. The process ends with a confirmation email.

However I ran into quite a few little hiccups. I perfected it and its been running for the past 4 months now. Its quite complex so I broke up the how-to into 3 separate blogs. I tried to note all the pitfalls and problems I had.

It's been awhile since I first wrote all this out so I may have a few typo's somewhere in the tutorial. I will be glad to edit/perfect it if someone has constructive criticism.

Click here for Part 1 of my tutorial
Reply With Quote
Old 05 Mar 2008, 06:16
andrewkhunn andrewkhunn is offline
Join Date: Feb 2007
This looks like it could be a useful series. Thanks for sharing.

I myself run a script every night that backs up all the MySQL DBs on the server into one gigantic tar.gz and then rsync it across to some cheap shared hosting for offsite backup purposes. The boxes themselves are fairly fault tolerant too, so I have about 3 layeres of protection from losing my data.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 15:47.

Layout Options | Width: Wide Color: