auto-backup across the net

[Kari Chisholm]

Wow.  Thanks for all the discussion on this one.  

I really am talking about a large stack of tiny little flatfiles
(largest one would be maybe 100K).  Is there a reason I couldn't just
a write a Perl script that, on a cron schedule, would cycle through
all the files looking for ones that have been changed since X time and
then FTP them to a second server?

-kari.



Kari Chisholm wrote:
> 
> Chris & Randal--
> 
> That's right: I'm building it in Perl myself.  The database size is
> actually quite small, but it's still mission-critical.
> 
> Basically, it's a large stack of tiny little flatfiles.  If I could
> write a script (called by cron) to look for all files that have
> changed, and then deliver them to someplace across the net - well,
> that'd be perfect.
> 
> -kari.
> 
> Chris Dawson wrote:
> >
> > I've not looked heavily into it, but I know MySQL supports replication,
> > which might be what you need.  This seems like a DB issue rather than a
> > programming issue.  So, I would look into documentation for MySQL or
> > Oracle or whatever database it is you are using before trying to write
> > something like this in Perl.
> >
> > http://www.mysql.com/doc/R/e/Replication_Intro.html
> >
> > You are using a database, right?  If you are creating your own database
> > using perl scripts, well, then I guess it is a perl issue.  :)
> >
> > Chris
> >
> > Kari Chisholm wrote:
> > > Friends--
> > >
> > > Here's the situation.  I'm building a mission-critical web-based
> > > database.  It's hosted on a server at, say,
> > > http://www.serverone.foo/bigdata.cgi.
> > >
> > > If that server goes down, even for an hour, I want to be able to
> > > immediately tell my clients to switch to another server (at another
> > > location) at, say, http://www.servertwo.foo/bigdata.cgi.
> > >
> > > In order to accomplish this kind of seamless transition, I need to
> > > ensure that data is backed up across the net in more-or-less real time
> > > - perhaps, every 5 minutes we ship changes to the data across the net.
> > >
> > > Is there an obvious solution or technology that I should be thinking
> > > of?  I'm almost exclusively a Perl guy, so solutions with Perl are a
> > > good thing, but I'm open to other thoughts...
> > >
> > > Thanks!
> > >
> > > -kari.
> > > TIMTOWTDI
> >
> > --
> > Chris Dawson
> > http://www.webiphany.com/
> > Send email to [ x at webiphany dot com ]
> TIMTOWTDI
TIMTOWTDI