Replication through ssh tunnels

Replication through ssh tunnels

am 05.09.2006 10:00:37 von Martin Andersen

Hi!

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
problem?

Any help is very appreciated.

Regards
/Martin Andersen

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