Melvyn Sopacua wrote:
>Does MySQL have any facility for using SSH to tunnel ports for use in
>replication? Has anyone implemented anything like this?
>We can't just assume if we create an SSH tunnel manually that the
>connection will stay up.
There was an excellent piece in August 2001's Sysadmin, that described
just that - for an intrusion detection system - but the principals remain
Unfortunately, it's not been published online:
"Distributed Intrusion Detection with Open Source Tools Jason Chan
Chan presents an example of an intrusion detection system comprising open
source tools such as Snort, OpenSSL, Stunnel, and MySQL. "
I remember that Stunnel is used to provide the tunneling and looking at
there's a complete example available:
Although I have not done this, couldn't you could use ssh port forwarding?
ssh -L <local port>:<mysql host>:<hostport>
mysql -h <local host> -P <local port>