MySQL replication Slave_IO_Running: No

MySQLmysql-replication

I have two servers that I am trying to get replication of one database between. I found a setup guide on sourceforge that I followed and I have tried various other settings since then, but no matter what I do, when I start the slave, the 'Slave_IO_Running' setting is always No….

I have no idea why or what to look at, any suggestions are appreciated.

The slave setup was:

CHANGE MASTER TO MASTER_HOST='myserver.mydomain.net', MASTER_USER='slave_user', 'MASTER_PASSWORD='mypassword', 'MASTER_LOG_FILE='mysql-bin.000011', MASTER_LOG_POS=1368363

(last data from today, trying to do setup again. I deleted and recreated the database on the slave from a new dump and tried to redo the setup.)

I have slave_user setup for %, localhost, and the specific IP of the slave computer but nothing seems to be working…

Thanks in advance for any advice or suggestions

Best Answer

As previously suggested, look in the var directory for the .err file. If it shows nothing, what if you issue: show slave status\G, it should print a line with the error.

Further to this, if you have the SQL thread running but the IO thread stopped, this suggests there's a problem in the communication between your slave and your master. From you "CHANGE MASTER" line, you are not specifying the port number. MySQL defaults to 3306, but are you running the server on that port? Also, is that file you are specifying, mysql-bin.000011 available in the master? And the master can read it, right?

Last, did you grant permissions for the replication user? (as in, have you done it properly, as MySQL manual specifies).

And, apart from this, don't know what else to check, maybe would sniff the network to see if there's any traffic, or just execute mysqlbinlog mysql-bin.000011 to see everything is fine there at that position.

Related Solutions

Mysql – Master master replication in thesql

Seems that like it's a problem with communication between the two mysql servers. Last_IO_Error: error connecting to master 'abc@192.xxx.x.xxx:3306.

Did you verify that
1) 192.xxx.x.xxx is listening either on 192.xx.x.xxx or 0.0.0.0/0
2) the other server, lets call it 192.xx.x.yyy can connect to it? Determine with mysql, netcat or something

Also seems no master log file nor position was entered. Im sure there are other problems with the configuration, it's very hard reading your configuration and pastes

Mysql – Setup a thesql replication, but new data are not updated

I think I see the problem

You have the following in your question:

Replicate_Do_DB: db1; db2

That is not supposed to be a semicolon-separated list. It is supposed to be a comma-separated list.

My guess is your have this in your slave's /etc/my.cnf

replicate-do-db=db1; db2

The correct way to set this up is

replicate-do-db=db1
replicate-do-db=db2

Please adjust this in the slave's /etc/my.cnf and restart mysql on the slave

Give it a Try !!!

UPDATE 2011-10-31 15:20 EDT

You may want to clear out the relay log by doing this

STOP SLAVE;
CHANGE MASTER TO master_log_file='mysql-bin.000008',master_log_pos-98;
START SLAVE;

then run SHOW SLAVE STATUS\G and make sure replication is running by making sure you see this

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

just as you posted in your question

Best Answer

Related Solutions

Mysql – Master master replication in thesql

Mysql – Setup a thesql replication, but new data are not updated

UPDATE 2011-10-31 15:20 EDT

Related Topic