I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
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.
How should relay-log.info look like?
Like this:
linuxweb1-bin.001
linuxweb1-bin.002
linuxweb1-bin.003
...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]