Re: mysql replication protocol

2002-08-31 Thread David Lloyd


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.

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

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysql replication protocol

2002-08-31 Thread Paul DuBois

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.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




mysql replication protocol

2002-08-30 Thread Vicky Gonzalez

Hi,

Does anyone know what protocol is used for the mysql replication process? Is it TCP or 
something proprietary? 

Thanks!
~Vicky


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysql replication protocol

2002-08-30 Thread Paul DuBois

At 15:29 -0700 8/30/02, Vicky Gonzalez wrote:
Hi,

Does anyone know what protocol is used for the mysql replication 
process? Is it TCP or something proprietary?

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.


Thanks!
~Vicky


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php