[wp-hackers] SVN: /branches/stable/

[Brian Layman]

Doug Wrote
>Backups run nightly, meaning
>that it's quite possible to lose up to and including an entire working
>day's worth of work.  

OK, I see your concern.  I'm sure your stuff is working well for you, but if
this info helps in some future meeting, I figured I'd share...  We handle
the need for a live backups though Database Mirroring.  It is very similar
to what you describe for file system, but with database tables.  In many
other engines, including a Berkeley DB and MySQL, it's known as Replication.
Basically all writes on a master server are automatically passed to one or
more clients.  That allows not only load spreading by creating multiple
query servers, but also creates a live backup that can easily be promoted to
a master - even if it is kept off site.

Here's BDB's take on database mirroring:
http://www.sleepycat.com/docs/ref/rep/intro.html

It's not something I'll ever use for BDB but if I ever find a sweet spot and
end up with an incredibly popular WordPress site, I figured I would use it
for the WordPress DB...  If you have *AMP at home, it should be a really
easy way ensure you have a good offsite backup of your site that can go live
in seconds or be fodder for a quick and complete restore...
http://dev.mysql.com/doc/refman/4.1/en/replication-howto.html

I should try it in the RW and make a post about it sometime...  I've not
played with it under MySQL yet.  BTW - this does not protect against having
your site attacked.  All writes/deletes, good and bad, are mirrored to the
other db.  So, this is not a replacement for full and rotating backups.

_______________________________________________
Brian Layman
www.TheCodeCave.com