Re: MySQL Secure Replication

2003-01-16 Thread Ivan Hoo
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

Re: MySQL Secure Replication

2003-01-16 Thread Ivan Hoo
> > 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

Re: MySQL Secure Replication

2003-01-15 Thread Ivan Hoo
> > > > 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

replication user privilege

2003-01-14 Thread Ivan Hoo
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

MySQL Secure Replication

2003-01-12 Thread Ivan Hoo
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 (