hi all,
- I am running process ssh background to use port forwarding of openssh.
- I have command:
ssh -g -f -p 11111 -i /path/private-key user1@ip-server1 -L 22222:ip-server2:33333 -N
- I use this tunnel ssh to replication mysql from server2 to localhost.
- The problem is process tunnel ssh no longer after interval time good run, so my replication is failed. I don't know when and why process tunnel ssh no longer?
- how can I trace process id ? I am used to "strace command", it is very good , but at this time process ssh backgroup have good status. So I cannot trace anything!!!
- anyone have ideals?
Big Thanks!!!

Hello,

The best thing to do in my opinion is manually connect and go through all the connection steps. Might be a misconfiguration causing a time out on the SSH connection which caused it to shutdown (the KeepAlive settings?).

Might I ask if you have any particular reason why you use SSH tunneling for MySQL replication? Don't you have a direct access from one server to the other so that you can setup MySQL replication directly? You could add an iptables rule to only permit connection from one to the other and vice versa for more security.

Kind regards,

Eric