« 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:
I'd recommend you to check
http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html for how this
'USE database' thing actually works with the binlog. But in a short answer:
yes, if you are extracting from the binlog the statements from only one
database, you should specify it when loading to the destination server.
--
Augusto Bott
On 7/5/07, spencer.c <spencer.crissman@...> wrote:
>
>
> 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@...> 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@...
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Is-Replicating-Data-from-Firewalled-Master-Possible--tf4026508.html#a11452754
> 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@...
>
>
http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html for how this
'USE database' thing actually works with the binlog. But in a short answer:
yes, if you are extracting from the binlog the statements from only one
database, you should specify it when loading to the destination server.
--
Augusto Bott
On 7/5/07, spencer.c <spencer.crissman@...> wrote:
>
>
> 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@...> 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@...
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Is-Replicating-Data-from-Firewalled-Master-Possible--tf4026508.html#a11452754
> 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?
| Free embeddable forum powered by Nabble | Forum Help |
