Network configuration:
- Firewall connected to Internet, with two ports: LAN (protected) and DMZ - Web server on the DMZ segment - Internal Servers on the LAN segment.
We would like to introduce a web database application on the Web server, using a Slave replication of a Master database running on the LAN Server.
We have two kinds of problems:
- For running replication we need to open ports on the LAN segment of the firewall to let the Slave read binary logs. - If we want web users to change information we need to operate on the Master Database (and open other ports).
Is there another kind of replication schema that keep security of the LAN segment ?
Alberto:
Perhaps a better question to ask is - is there a different kind of topology that will allow you replicate securely and meet your other goals?
E.g - keep both the master and the slave on the secure LAN, and open the MySQL port on the master to only to your web server in the DMZ.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
