[Gllug] Mysql replication

[Andy McGarty]

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