Does START SLAVE fail?
If so, what is the output of SHOW SLAVE STATUS?
On Fri, Mar 5, 2010 at 10:11 AM, Steven Staples <sstaples@stripped> 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,
> 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
> 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=1