MySQL Forums
Forum List  »  Replication

Slave_IO_Running or Slave_SQL_Running
Posted by: Dan Casey
Date: June 21, 2005 06:34PM

This setup is using one master and two slaves.

master- Mysql 4.0.20 - working
slave1 - Mysql-4.0.20 - ?????
slave2 - Mysql 4.0.17 - working

as far as i know the data seems to be ok. but i am a little bit unsure about some of the output of show slave status..

when i run show slave status on slave2 i see the folloing two things,
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

However, When i run show slave status on slave1 i get
Slave_IO_Running: Yes
Slave_SQL_Running: No

I looked at the mysql documentation. I know what in for the IO thread and one is the SQL thread.. didn't really say anything else unless i missed something... What are these for? or better yet, What will break if one of them says "No"???

Log file and position seem in sync with the master. Whats going on here?

I also tried doing slave stop; slave start; and that didn't help...

Options: ReplyQuote

Written By
Slave_IO_Running or Slave_SQL_Running
June 21, 2005 06:34PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.