Hi,
I have a mysql replication going but when ever the network connection is lost from the master side the slave tries to reconnect. If the slave cannot reconnect it will try to reconnect again after 60 seconds. Is there anyway i can change this value to something lower.
After pulling the network plug the following is recorded on /var/log/mysqld.log
"090204 14:34:20 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000041' position 98
090204 14:34:20 [ERROR] Slave I/O thread: error reconnecting to master 'slave_user@127.0.0.1:3307': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0' errno: 2013 retry-time: 60 retries: 86400
090204 14:36:20 [Note] Slave: connected to master 'slave_user@127.0.0.1:3307',replication resumed in log 'mysql-bin.000041' at position 98"
So its the variable retry-time i want to change. I tried adding "retry-time=10" to the my.cnf but this variable doesnt exist. So i read
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html and the only variable with default value of 60 was "net-write-timeout" so i tried changing that and still didn't work. Is there any way of changing this value?
Thanks