RE: Is Replicating Data from Firewalled Master Possible?

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@gmail.com [mailto:augusto.bott@gmail.com]
> On Behalf Of Augusto Bott
> Sent: Wednesday, July 04, 2007 3:24 PM
> To: spencer.c
> Cc: replication@lists.mysql.com
> 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@gmail.com> 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@gmail.com
> >
> >
>

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com