[Gllug] Mysql replication

william pink will.pink at gmail.com
Mon Mar 30 12:32:36 UTC 2009


On Mon, Mar 30, 2009 at 1:23 PM, Andy McGarty <andy at mac1systems.com> wrote:

> >
> >
> > Ah now theres a problem I don't know the position of the master at the
> > time
> > of the dump, looks like I have to write a script to send me the master
> > status at the time of the dump then and do it tomorrow night.
> >
> >
> > Thanks Andy
> >
> > Will
>
> Is it quiet enough at night to do a "load from master"?  Can take a while
> if its a big database.
>
> And the master is locked as it transfers.
>
> Andy
>
> --
> Gllug mailing list  -  Gllug at gllug.org.uk
> http://lists.gllug.org.uk/mailman/listinfo/gllug
>


It would be yeah but I have a Mysql slave that I was planning to use with a
ssh tunnel so this would take a really long time and I would rather do both
slaves at the same time.

Will
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20090330/2d9508d5/attachment.html>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug


More information about the GLLUG mailing list