Rails - Jan 2010 - What backup approach for uploaded files stored in file system???

Hi,

I''m wondering what backup/recovery approach do people use/recommend
when they have an application that has not only a database (mysql in
my case), but uploaded files that are stored in a file system (using
paperclip in my case)?

Also part of the question I guess is how much one should trust the
hosting provider re how it does or doesn''t make backups of filesystem/
database, and if you had to how quickly they would be able to do a
restore for you.

Note I''m on http://dreamhost.com/ at the moment by the way, on shared
hosting.

Thanks

--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

PS - Checked with dreamhost & they do make filesystem (domain)
backups, but they quite clearly say they do not guarentee things here,
and recommended/offer an approach for you to do a complete domain
download every 30 days.  The only issue here then is the amount of
downloading you''d have to do...which would then make one wonder
whether it might be more cost effective storing the uploaded files
directly on something like S3 to start with perhaps?   any comments

On Jan 2, 8:33 am, greghauptmann
<greg.hauptm...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hi,
>
> I''m wondering what backup/recovery approach do people
use/recommend
> when they have an application that has not only a database (mysql in
> my case), but uploaded files that are stored in a file system (using
> paperclip in my case)?
>
> Also part of the question I guess is how much one should trust the
> hosting provider re how it does or doesn''t make backups of
filesystem/
> database, and if you had to how quickly they would be able to do a
> restore for you.
>
> Note I''m onhttp://dreamhost.com/at the moment by the way, on
shared
> hosting.
>
> Thanks
--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

My advice would be to either setup a script to download the files (and  
a dump of your database!) to your local machine/server or automate the  
process and dump it on S3.  Or both.

If your ISP has a problem, you are *one* of thousands (or tens of  
thousands) of clients.  In other words, you''re not important -- or  
just as important as everyone else.

The relevant questions when talking about backups are...

- Can we afford to lose the data?
- How long can we afford to not have the site up and available?

The more critical the site/data the more important backups -- and a  
(tested) restore plan is.

Good luck!

-philip

On Jan 1, 2010, at 3:22 PM, greghauptmann wrote:
> PS - Checked with dreamhost & they do make filesystem (domain)
> backups, but they quite clearly say they do not guarentee things here,
> and recommended/offer an approach for you to do a complete domain
> download every 30 days.  The only issue here then is the amount of
> downloading you''d have to do...which would then make one wonder
> whether it might be more cost effective storing the uploaded files
> directly on something like S3 to start with perhaps?   any comments
>
> On Jan 2, 8:33 am, greghauptmann
<greg.hauptm...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>> Hi,
>>
>> I''m wondering what backup/recovery approach do people
use/recommend
>> when they have an application that has not only a database (mysql in
>> my case), but uploaded files that are stored in a file system (using
>> paperclip in my case)?
>>
>> Also part of the question I guess is how much one should trust the
>> hosting provider re how it does or doesn''t make backups of  
>> filesystem/
>> database, and if you had to how quickly they would be able to do a
>> restore for you.
>>
>> Note I''m onhttp://dreamhost.com/at the moment by the way, on
shared
>> hosting.
>>
>> Thanks
>
> --
>
> You received this message because you are subscribed to the Google  
> Groups "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonrails- 
> talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
> .
> For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
> .
>
>
--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

I have a set of Capistrano recipes that dumps the database and shared
assets to another server/machine for each application. You can
download them from:

http://github.com/firsthand/application-backup

What I like about this approach is that all the backup configuration
is centralized along with the archives themselves.Need to backup a new
application, just add another config.

There are some other alternatives here as well:

http://www.ruby-toolbox.com/categories/backups.html

HTH,
Nicholas

---
Nicholas Henry
Ruby on Rails Developer
nicholas-avpPrnUtcvTqJdGyAr2GoA@public.gmane.org

Firsthand Web Design and Development

Website
http://www.firsthand.ca

Twitter
http://twitter.com/firsthand

Blog
http://blog.firsthand.ca/









On Jan 1, 5:33 pm, greghauptmann
<greg.hauptm...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hi,
>
> I''m wondering what backup/recovery approach do people
use/recommend
> when they have an application that has not only a database (mysql in
> my case), but uploaded files that are stored in a file system (using
> paperclip in my case)?
>
> Also part of the question I guess is how much one should trust the
> hosting provider re how it does or doesn''t make backups of
filesystem/
> database, and if you had to how quickly they would be able to do a
> restore for you.
>
> Note I''m onhttp://dreamhost.com/at the moment by the way, on
shared
> hosting.
>
> Thanks
--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

greghauptmann wrote:
> Hi,
> 
> I''m wondering what backup/recovery approach do people
use/recommend
> when they have an application that has not only a database (mysql in
> my case), but uploaded files that are stored in a file system (using
> paperclip in my case)?
Hi,

So what did you end up using? Incremental backups?
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

On 07 Jul 2010, at 17:42, Fernando Perez wrote:
>> I''m wondering what backup/recovery approach do people
use/recommend
>> when they have an application that has not only a database (mysql in
>> my case), but uploaded files that are stored in a file system (using
>> paperclip in my case)?
>
> Hi,
>
> So what did you end up using? Incremental backups?
We use rsync to synchronize folders between two servers, it''s always  
possible to do some kind of archiving or revision management on the  
remote server (which is what we do too).


Best regards

Peter De Berdt

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.