At 10:55 +0200 8/31/02, David Lloyd wrote:
>Paul,
>
>(mysql, query)
>
>> It *can* use TCP, but that's just the transport protocol through which
>> the replication information is processed. Replication can also be
>> done between two servers on the same host, using a UNIX socket or (on
>> a Windows box) a named pipe. The "replication protocol" itself is
>> MySQL-specific.
>
>I would assume, then, that if it were done over TCP/IP that one could
>setup ipsec to secure it.
Presumably, yes.
>
>Just out of interest (and hit me if it's in the manual somewhere ;-P),
>does the replication protocol offer any cryptographically secure method
>of replication if one wants it?
>
>DSL
MySQL 4 supports SSL. The server supports master-ssl, master-ssl-key,
and master-ssl-cert options, which are analogous to the non-master
options...the server's help message does warn that this is relatively
new. As is SSL in MySQL in general.