From: Hank
Date: May 8 2007 5:55pm
Subject: duplicating a replicated slave environment
List-Archive: http://lists.mysql.com/mysql/206644
Message-Id: <1990a96b0705081055m64497277h3b40f08efe9f47b8@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_49368_22171430.1178646921520"

------=_Part_49368_22171430.1178646921520
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello All,

I have a 4.1.14 mysql database master and slave set up.

For this slave #1, I have the IO thread running constantly, and the SQL
thread running once a day to update all pending updates from the master
(then I shut it off).  So for most of the day, this database is static
(except for the collecting relay logs).

I have a new machine to be another slave of the same master (slave #2).

I can not shut down or lock the master in order to copy the master database
to the slave #2 (it is 44GB total, and would take over an hour to copy).

I have copied the (static) database from Slave #1 to Slave #2.  How can I
now configure Slave #2 to process the pending relay-logs and bring it up to
date?

Obviously I would need to copy (and rename?) the relay logs, but what about
the master.info and relay-log.info files?

Or in other words, can I use the show slave status information on Slave #1
to setup Slave #2 in the CHANGE MASTER TO command?

Thanks.

-Hank

------=_Part_49368_22171430.1178646921520--