Hello,
Is there any way to fix a connection of replication
from slave host when user on slave host noticed
that the connection of replication had been lost?
Now I have a following environment.
MySQL Master server <== replication ==> MySQL Slave server
Both server has
Turbo Linux 8.0 WS
MySQL-4.0.18.
Master has a global IP address and has good network performance.
Slave is connected to Internet with 64kbps.
By a network problem, the connection between slave server
and Internet often drops.
So I want to make a command like "mysql_synchronize" which
tries to fix the connection of replication immediately.
I think that a possible script for the command is like
mysql --host=master_host -e "show master status"
# memory master_log_pos and master_log_file
mysql --host=slave_host -e \
"stop slave; start slave; select master_pos_wait('master_log_file',master_log_pos);"
Are there any better script?
Now I am using following parameters (these are default values).
slave_net_timeout=3600
master-connect-retry=60
I think these values should be decreased in my environment.
slave_net_timeout=30
master-connect-retry=10
If I use above values, it will not be necessary to use "mysql_synchronize".
But I think these values cause a wasting network traffic.
Any ideas?
Thanks,
--
Yasumitsu Ito
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
