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 > <[EMAIL PROTECTED]> wrote: > > On 2008-10-09 22:13, Nick Smith wrote: > > On Thu, Oct 9, 2008 at 3:38 PM, David Rees > <[EMAIL PROTECTED]> 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: > [EMAIL PROTECTED] > > *********************************************************************** > * 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 > [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/ ------------------------------------------------------------------------- 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/
