Unix Technical Forum

Restarting/Rebuilding Slave

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 ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-24-2008, 06:08 PM
Ashley M. Kirchner
 
Posts: n/a
Default Restarting/Rebuilding Slave


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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:34 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com