You might be able to do something with SSH port forwarding -
http://www.ssh.com/support/documentation/online/ssh/adminguide/32/Port_Forwarding.htmlThe internal server can SSH out through the firewall to the external
server, and set up a port forward back to itself.
Reliability might be an issue - if the tunnel fails you need to detect it
and recover it somehow
"spencer.c" <
spencer.crissman@...>
04/07/2007 22:01
To
replication@...
cc
Subject
Is Replicating Data from Firewalled Master Possible?
I need to replicate data from a server inside our firewall to a server
outside our firewall. The server outside of our firewall will not have
any
access through the firewall, so the typical MySQL replication setup
doesn't
seem viable, as to use it the slave has to be able to connect to the
master
to retrieve the data.
Is there a straightforward way to replicate the data from the internal
server to the outside server in this scenario? I just want to push the
data
out to a single receiver, on an ongoing basis, rather than have the
external
server pull it down.
Thanks for any help.
--
View this message in context:
http://www.nabble.com/Is-Replicating-Data-from-Firewalled-Master-Possible--tf4026508.html#a11437456Sent from the MySQL - Replication mailing list archive at Nabble.com.
--
MySQL Replication Mailing List
For list archives:
http://lists.mysql.com/replicationTo unsubscribe:
http://lists.mysql.com/replication?unsub=f.clement@...Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number
741598.
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU
