[ubuntu-uk] mySQL over ssh tunnel?

[Michael Holloway]

On Thu, 2007-12-06 at 11:40 +0000, Lucy wrote:
> On 06/12/2007, Michael Holloway <michael at thedarkwinter.com> wrote:
> > Hi Guys
> >
> > I want to ask you opinion on this...
> >
> > I want to have a mysql asynchronous replication slave connected over the
> > internet (through IP validating firewalls, not VPN).
> >
> > Is it secure to just use a normal mysql connection? Or is the data
> > un-encrypted, and if so, how easy to sniff/intercept?
> >
> > I'm guessing that using an SSH tunnel (something i've never done before)
> > is the best way to do this??
> >
> > Any opinions/pointers?
> 
> You can setup MySQL to use a secure connection without having to setup
> your own SSH tunnel. See:
> http://dev.mysql.com/doc/refman/5.0/en/secure-connections.html
> 

Thanks Lucy, but the problem is the slave is on managed server running
mysql-server4... which doesn't support ssl (as far as i can tell).
Hmm, Which raises a second query about whether replication between v4
and v5 even works...???