469,927 Members | 1,790 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

Replication through ssh tunnels

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

Sep 5 '06 #1
0 3118

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Cherrish Vaidiyan | last post: by
reply views Thread by Cherrish Vaidiyan | last post: by
3 posts views Thread by steve | last post: by
3 posts views Thread by dlesandrini | last post: by
9 posts views Thread by David W. Fenton | last post: by
3 posts views Thread by Gert van der Kooij | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.