FLUSH LOGS will make this approach simpler -- then you are copying whole
files, and the position is always start-of-file.
Port-forwarding mentioned later is probably better.
> -----Original Message-----
> From:
augusto.bott@... [mailto:
augusto.bott@...]
> On Behalf Of Augusto Bott
> Sent: Wednesday, July 04, 2007 3:24 PM
> To: spencer.c
> Cc:
replication@...
> Subject: Re: Is Replicating Data from Firewalled Master Possible?
>
> 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-Mast> er-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@...> >
> >
>
--
MySQL Replication Mailing List
For list archives:
http://lists.mysql.com/replicationTo unsubscribe:
http://lists.mysql.com/replication?unsub=lists@...