is there any way you can implement a secure replication via ssh or sth else?
regards,
ivan
> At 23:17 +0800 1/16/03, Ivan Hoo wrote:
> > > > there seem to be a lack of documentation on this part.
> >>
> >> Mostly because it can't be done (that I'm aw
> > there seem to be a lack of documentation on this part.
>
> Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the documentation already. i can
understand that if 4.0.x is still in alpha or beta stage. but now it is
almost near release (gamma).
the official
> >
> > Except with stunnel (often recommended) or SSH (which I've had running
> > for months doing this). PS, as with the MySQL daemon, I run my ssh
> > tunnel under 'supervise' so as to make sure its always there and
> > restarts if it gets killed / dies / is stupid / upgraded.
>
> Right. I sho
for a normal replication, you need to create a replication user by issuing
such command:
GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '';
for a secured replication (mysql-4.0.7-gamma), do you need to issue a
REQUIRE SSL, eg:
GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '' REQUIRE SSL;
but when RE
hi All,
has anyone been able to setup ssl secure replication for mysql? how do i
know whether the replication is actually done over ssl? there seem to be a
lack of documentation on this part. appreciate a lot if someone could
provide some feedback on this. i m currently running mysql-4.0.7-gamma
(