Oops meant to include the list on that one :) Begin forwarded message:
Date: Wed, 27 Mar 2002 14:11:54 +0000 From: Chris Wilson <[EMAIL PROTECTED]> To: Benji Spencer <[EMAIL PROTECTED]> Subject: Re: Replication Connection: Slave -> Master? On Wed, 27 Mar 2002 07:21:11 -0600 Benji Spencer <[EMAIL PROTECTED]> wrote: > We are looking at using replication between two MySQL servers. In our > situation, there might be a firewall between the two servers and we will > need to permit the traffic between the two through the firewall. > > From what I have read, it sounds like the Slave connects to the Master (in > stead of the master to the slave, or even the slave contacting the master, > and then the master establishing a connection to the slave). Is this (Slave > -> Master) correct? It also seems as if the data transfer happens on port > 3306 (by default). THis is also correct? Yes the slave makes a connection to the master on port 3306 (by default - you can change this) - just like a regular [remote] mysql client. Unless you're using mysql 4.x with it's SSL support then bear in mind that all data is unencrypted so if you're going to send it over an insecure network you might want to pipe it down something like an SSH tunnel (you can then have SSH compress the stream too) or perhaps use something like CIPE (http://freshmeat.net/projects/cipe) to create a VPN between the slave and master systems. HTH Chris -- Chris Wilson <[EMAIL PROTECTED]> http://www.wapmx.com --------------------------------------------------------------------- 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
