If you replicate your live database to a spare database, you can then
perform backup tasks on the spare. The reason to backup to spare is that
you can use the pre and post dump commands to shutdown the database for the
backup. This solves a number of issues from file locking on the database.
You could even run the second database right on your backuppc server. You
could sync up a number of databases to a single instance of MySQL or
PostgreSQL on the backuppc box and then backup the directories with backuppc
and be able to shutdown those databases during the backup.
On Sat, Oct 11, 2008 at 9:46 PM, Philip Tait <[EMAIL PROTECTED]> wrote:
> 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
> [email protected]
> List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
> Wiki: http://backuppc.wiki.sourceforge.net
> Project: http://backuppc.sourceforge.net/
>
-------------------------------------------------------------------------
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
[email protected]
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
