On Sat, 2008-10-11 at 22:47 +0000, John Rouillard wrote:
> On Fri, Oct 10, 2008 at 08:00:33PM -1000, Philip Tait wrote:
> > If you run a second MySQL, why not configure it as a replicated slave?
> > Works well for us.
> 
> and what happens when somebody runs a cascaded delete that wipes your
> database? Replication is not a replacement for backups.

My suggestion was in response to "dan":
"for backing up MySQL databases, why not run a second MySQL and sync
them on a schedule? Then if you have a problem you dont even need to
restore, you can just switch to the other server or restart the first
machine and sync the other way? If you do this you can sync, then stop
the backup so you can dump that to disk/tape/etc etc."

I don't see where this excludes backing up the database as well.

Philip J. Tait
http://subarutelescope.org


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/