Thanks for the feedback. It looks like that will work. I will make a script on the master that runs the logs through mysqlbinlog and pipes the commands to the external server.
When I am doing this, if I specify -d dbname for mysqlbinlog, will I need to have selected the appropriate database in my mysql connection before sending the commands? Browsing through the output from the mysqlbinlog, I don't see any "USE DATABASE" commands or anything that would direct the queries to specific databases, so I was just curious about that.
Anyway, thanks again for getting me pointed in the right direction.
Augusto Bott-4 wrote:
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-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@gmail.com>
>
