to:anan...@gmail.com]
Sent: March 8, 2010 11:45 AM
To: Steven Staples
Cc: Johnny Withers; mysql@lists.mysql.com
Subject: Re: Master/Slave - trucate master table
did u stop the slave process before stopping mysql on slave.
Did u do the below before stopping the mysql on slave?
slave stop;
show slave sta
XXX.
>
>
>
>
> Steven Staples
>
>
> -Original Message-
> From: Johnny Withers [mailto:joh...@pixelated.net]
> Sent: March 5, 2010 1:11 PM
> To: Steven Staples
> Cc: mysql@lists.mysql.com
> Subject: Re: Master/Slave - trucate master table
>
> Does START SLA
te on the master, where ID <
.
Steven Staples
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: March 5, 2010 1:11 PM
To: Steven Staples
Cc: mysql@lists.mysql.com
Subject: Re: Master/Slave - trucate master table
Does START SLAVE fail?
If so, what is th
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 g
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
bee