This is a discussion on Restarting/Rebuilding Slave within the MySQL General forum forums, part of the MySQL category; --> I'm rebuilding a server that is a slave to our primary. At this point in the game, I can ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I'm rebuilding a server that is a slave to our primary. At this point in the game, I can no longer access anything on the slave server (its main drive is being rebuild). However, I do have a full rsync of the /var/lib/mysql folder that was on it (this rsync was done AFTER MySql was properly shutdown on this server.) And I have all the info from the master server as well. So the question is, once I finish rebuilding this machine and I install MySQL back on it, what's the proper or safest way to rebuild the slave setup and get it going again (and pick up where it left off before the machine went down)? Can I simply rsync all the files back and start MySQL? Looking at the rsynced data, I can see the -relay-bin files, all the mysql-bin files, and all the individual databases in their respective folders: drwx------ 2 mysql mysql 12288 Sep 11 2007 lif1/ drwx------ 2 mysql mysql 4096 Apr 3 10:00 lif2/ drwx------ 2 mysql mysql 16384 Mar 4 19:00 lotro/ drwx--x--x 2 mysql mysql 4096 Apr 14 2007 mysql/ drwxr-xr-x 2 mysql mysql 4096 Apr 13 11:59 test/ drwx------ 2 mysql mysql 4096 Jan 28 10:54 wonderland/ -rw-rw---- 1 mysql mysql 10485760 Apr 22 10:30 ibdata1 -rw-rw---- 1 mysql mysql 5242880 Apr 22 10:30 ib_logfile0 -rw-rw---- 14 mysql mysql 5242880 May 11 2007 ib_logfile1 -rw-rw---- 1 mysql root 25480 Apr 22 10:30 lilpusher.err -rw-rw---- 1 mysql mysql 4607313 Apr 22 10:30 lilpusher-relay-bin.005216 -rw-rw---- 3 mysql mysql 29 Apr 20 05:42 lilpusher-relay-bin.index -rw-rw---- 1 mysql mysql 23176 Apr 22 10:30 log.0000000001 -rw-rw---- 1 mysql mysql 84 Apr 22 10:28 master.info -rw-rw---- 14 mysql mysql 117 May 11 2007 mysql-bin.000001 -rw-rw---- 14 mysql mysql 117 May 11 2007 mysql-bin.000002 -rw-rw---- 14 mysql mysql 117 May 21 2007 mysql-bin.000003 -rw-rw---- 14 mysql mysql 98 May 21 2007 mysql-bin.000004 -rw-rw---- 14 mysql mysql 117 Jun 15 2007 mysql-bin.000005 -rw-rw---- 14 mysql mysql 117 Aug 11 2007 mysql-bin.000006 -rw-rw---- 14 mysql mysql 117 Sep 25 2007 mysql-bin.000007 -rw-rw---- 14 mysql mysql 117 Oct 24 10:06 mysql-bin.000008 -rw-rw---- 14 mysql mysql 117 Oct 28 09:50 mysql-bin.000009 -rw-rw---- 14 mysql mysql 117 Nov 6 12:26 mysql-bin.000010 -rw-rw---- 14 mysql mysql 117 Dec 23 03:15 mysql-bin.000011 -rw-rw---- 1 mysql mysql 117 Apr 22 10:30 mysql-bin.000012 -rw-rw---- 14 mysql mysql 228 Dec 23 03:18 mysql-bin.index -rw-rw---- 1 mysql mysql 66 Apr 22 10:28 relay-log.info -- W | It's not a bug - it's an undocumented feature. +-------------------------------------------------------------------- Ashley M. Kirchner <mailto:ashley@pcraft.com> . 303.442.6410 x130 IT Director / SysAdmin / Websmith . 800.441.3873 x130 Photo Craft Imaging . 3550 Arapahoe Ave. #6 http://www.pcraft.com ..... . . . Boulder, CO 80303, U.S.A. |