[Gllug] Mysql replication

[william pink]

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

> On Mon, 30 Mar 2009 12:08:31 +0100, william pink <will.pink at gmail.com>
> wrote:
>
> > Hi,
> >
> > I have had a bit of a search and I couldn't find any information google
> > that
> > I was after,
> >
> > My Mysql replication broke not so long ago so I have decided to
> > reconfigure
> > it from scratch the only problem I have is the site is quite a high
> > traffic
> > site and a Mysqldump is going  to take far to long wait for, I have a
> > dump
> > from this morning that I could use and and from what I can see the slave
> > should catch up on the days changes to the same point as the Master is
> > this
> > an ideal approach to take?
> >
> > Thanks,
> > Will
> As long as you know where it was in the master when you did the copy then
> it should be ok.  The slave should catch up quite quickly.  You can
> monitor it by looking at how many seconds the slave is behind the master.
> If it starts to increase then you are in trouble :(
>
>
> Andy
>
> --
> Gllug mailing list  -  Gllug at gllug.org.uk
> http://lists.gllug.org.uk/mailman/listinfo/gllug


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20090330/d320c3c4/attachment.html>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug