Re: Restore 20 gigabytes of binary logfiles

[Jeremy Zawodny]

On Thu, May 13, 2004 at 10:28:26AM +0200, JFL wrote:
> >> I need to restore 20 gigabytes of binary logfiles.
> >> What should I do in order to get the job done as quickly as possible?
> >>
> >> I am considering this:
> >> mysqlbinlog --database=mydb logfiles | mysql -f
> > 
> > There is a faster way, but it is rather tricky.
> > 
> > 4.0 slave can be tricked into thinking that those binary logs are in 
> > fact the relay logs that it gathered from the master. So we trick the 
> > server into thinking it is a slave of the server that produced them. You 
> > just need to pick a server-id that is not the same as the one that 
> > produced them. Then if you list the logs in in the relay log info file 
> > in the correct order, hand-craft relay-log.info file to point at the 
> > first one), then start the slave with skip-slave-start, and then just 
> > start the SQL thread manually (SLAVE START SQL_THREAD), it will process 
> > them until it is done. Periodically run SHOW SLAVE STATUS to see if it 
> > got to the end of the last log.
> 
> Would that be faster than having converted the binary logs to sql 
> commands in one file and then use that?

It would be, yes.  It's hard to say how much faster though.
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

[book] High Performance MySQL -- http://highperformancemysql.com/