Jose,
Thank you very much...I found that fix a few minutes before I read your
email...however I really appreciate your assistance.
Just an FYI to anyone one else though...I had to skip a total of 2
queries (I executed SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; two times)
because of the particul
maybe if you put on the slave server :
mysql> STOP SLAVE;
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
mysql> START SLAVE;
then just to check take a look at this lines :
mysql> show slave status\G;
...
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
...
it will restart the r
Hello all,
I noticed that my two Mysql slave servers were running out of sync this
morning. After looking into it...it appears that yesterday when I tried
to change the username of a user on the master server...it caused some
issues on the slaves. Here is what I was able to pull from the slav
Replying to list, as one suggestion does involve the database :-)
On Fri, Jan 9, 2009 at 3:03 AM, xufeng wrote:
> Hi all,
> Recently I am redesigning our website architecture.
> I have two servers located at Location_A and Location_B serving the same
> http://www.ourexample.com and loadbalancin
