| Bug #26100 | replication on vpn | ||
|---|---|---|---|
| Submitted: | 6 Feb 2007 3:34 | Modified: | 9 Mar 2007 12:08 |
| Reporter: | mingfei hua | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S1 (Critical) |
| Version: | 5.0.27 | OS: | Linux (linux) |
| Assigned to: | CPU Architecture: | Any | |
[6 Feb 2007 9:17]
Sveta Smirnova
Thank you for the report. Please provide values of slave-net-timeout, master-retry-count and master-connect-retry options of your slave.
[7 Feb 2007 5:50]
mingfei hua
slave-net-timeout=3600 master-retry-count default value master-connect-retry default value May I can set the parameter slave-net-timeout smaller,I maybe help for my problem.
[9 Feb 2007 12:08]
Sveta Smirnova
Yes, please, make slave-net-timeout smaller and examine how it will work. Especcially because with other type of connetions (not VPN) all work fine.
[10 Mar 2007 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: I create replication between two mysql server connecting via IPSEC VPN. I found it did not work stable . sometime ,the replication is not work,the sql executed in mater have not been replicated to slave, but I check the status of slave server, it looks will,the output is like *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 10.0.0.15 Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: binlog.000001 Read_Master_Log_Pos: 176374210 Relay_Log_File: info68-relay-bin.000172 Relay_Log_Pos: 232 Relay_Master_Log_File: binlog.000001 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 176374210 Relay_Log_Space: 232 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 1 row in set (0.00 sec) I check "show master status " in master ,it like *************************** 1. row *************************** File: binlog.000001 Position: 176374301 Binlog_Do_DB: Binlog_Ignore_DB: 1 row in set (0.00 sec) A hours later ,the result of "show master status " and "show slave status " is same. New data insert in master server will not replcated to slave server. I run "netstat -na|grep 3306" in slave server,found the socket connection,the print output like : tcp 0 0 100.100.100.20:51781 10.0.0.15:3306 ESTABLISHED but run the same command in master server,nothing found. I restart slave thread in slave server , replication work wil again,but sometime later,the problem is occur. I think the VPN connection is not very stable,but mysql repliction should find the connection error,and restart the slave thread auto. How to repeat: none