« Return to Thread: Is Replicating Data from Firewalled Master Possible?

Re: Is Replicating Data from Firewalled Master Possible?

by Augusto Bott-4 :: Rate this Message:

Reply to Author | View in Thread

Why don't you just copy the binlogs from time to time from the master to the
slave and then apply them in batches?
This way you don't need the slave to connect to its master (since the
binlogs would be applied manually or via a script one by one)

--
Augusto Bott

On 7/4/07, spencer.c <spencer.crissman@...> wrote:

>
>
> 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#a11437456
> Sent from the MySQL - Replication mailing list archive at Nabble.com.
>
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe:
> http://lists.mysql.com/replication?unsub=augusto.bott@...
>
>

 « Return to Thread: Is Replicating Data from Firewalled Master Possible?