From: Johnny Withers Date: March 5 2010 6:10pm Subject: Re: Master/Slave - trucate master table List-Archive: http://lists.mysql.com/mysql/220863 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6d6481529fd2f048111a3fb --0016e6d6481529fd2f048111a3fb Content-Type: text/plain; charset=ISO-8859-1 Does START SLAVE fail? If so, what is the output of SHOW SLAVE STATUS? JW On Fri, Mar 5, 2010 at 10:11 AM, Steven Staples wrote: > Good day everyone... > > I am working with a master/slave set up, and of course, we started it once > the database tables were a combined size of 60gb+ > > We've got it running and in sync now, (stopped the master, deleted the bin > files, rsync'd the database tables and restarted the master) and all has > been fine for the last week... until today. > > We stopped the mysql process on the slave, and did a backup (due to size, > we > just rsync and backup the rsync) of the table files. Took about 40 minutes > to do (still not sure why it was that long, but anyway), and then we > restarted the slave mysql. We're getting an error now. Apparently one of > the tables is out of sync now? What appears to have happened, is that > when > the slave was down, i truncated a table on the master. > > I've read that this sometimes causes errors, is this a bug? Or a is there > something I should do differently? > > > Steven Staples > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=johnny@stripped > > -- ----------------------------- Johnny Withers 601.209.4985 johnny@stripped --0016e6d6481529fd2f048111a3fb--