If you run a second MySQL, why not configure it as a replicated slave?
Works well for us.
Philip J. Tait
http://subarutelescope.org
On Fri, 2008-10-10 at 20:27 -0600, dan wrote:
> 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.
>
> Thoughts?
>
> On Fri, Oct 10, 2008 at 2:26 AM, Paul Bijnens
> <Paul.Bijnens AT xplanation DOT com> wrote:
>
> On 2008-10-09 22:13, Nick Smith wrote:
> > On Thu, Oct 9, 2008 at 3:38 PM, David Rees
> <drees76 AT gmail DOT com> wrote:
> > >
>
> > > As long as the file names remain the same and you are
> using rsync,
> > > only the changes will be downloaded.
> > >
>
> > Do you know how it does that? I thought it just checked
> checksums to
> > see if they were different? How can it just download the
> changes to a
> > large DB like that if its all contained in a single file DB?
>
>
> That is the virtue of the rsync algorithm.
> See: http://en.wikipedia.org/wiki/Rsync
>
>
> --
> Paul Bijnens, xplanation Technology Services Tel +32
> 16 397.511
> Technologielaan 21 bus 2, B-3001 Leuven, BELGIUM Fax +32
> 16 397.512
> http://www.xplanation.com/ email:
> Paul.Bijnens AT xplanation DOT com
>
> ***********************************************************************
> * I think I've got the hang of it now: exit, ^D, ^C, ^\, ^Z,
> ^Q, ^^, *
> * F6, quit, ZZ, :q, :q!, M-Z, ^X^C, logoff, logout, close,
> bye, /bye, *
> * stop, end, F3, ~., ^]c, +++ ATH, disconnect, halt, abort,
> hangup, *
> * PF4, F20, ^X^X, :D::D, KJOB, F14-f-e, F8-e, kill -1 $$,
> shutdown, *
> * init 0, kill -9 1, Alt-F4, Ctrl-Alt-Del, AltGr-NumLock,
> Stop-A, ... *
> * ... "Are you sure?" ... YES ... Phew ... I'm out
> *
>
> ***********************************************************************
>
>
>
> -------------------------------------------------------------------------
> 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/
>
>
>
> -------------------------------------------------------------------------
> 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/
-------------------------------------------------------------------------
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/
|