Replication through ssh tunnels

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I have a problem with replication.
The master database resides on machine A, and the slave on machine B.
The replication is performed through an SSH tunnel. This SSH tunnel is
created using autossh to reestablish the connection if it times out or
is lost in any way.

However, whenever this ssh tunnel breaks, and restarts, the slave binary
log (relay log) is corrupted and the replication slave stops. This
happens daily, rendering the replication very unstable.

Anyone has an idea of any alternative method or any solutions to the

Any help is very appreciated.

/Martin Andersen

Mysql version:
$ mysqladmin --version
mysqladmin  Ver 8.41 Distrib 5.0.22, for pc-linux-gnu on i486

Site Timeline