Chris Petersen <[EMAIL PROTECTED]> wrote:
> I'm trying to set up two-way replication between our colo and our office
> (slow DSL line), so our web customers can get the fast speeds of our
> colo, and the people in the office can also get the fast speeds of our
> internal network.
>
> Since our colo machine is logging customer shopping cart info (etc.)
> that we don't need to send down the pipe to the office (and vice versa,
> a lot of stuff happening in-office that doesn't need to go out to the
> main web db box), is there any way to tell the MASTER not to send info?
> I can only see slave controls in the documentation (things like
> replicate-ignore-table or replicate-do-table), but those don't seem to
> prevent the data from being sent to the slave, only whether or not the
> slave decides to use it.
>
You can restrict logging only on the database level with binlog-do-db/binlog-ignore-db
options:
http://www.mysql.com/doc/en/Binary_log.html
Take a look also at SET SQL_LOG_BIN command:
http://www.mysql.com/doc/en/SET_SQL_LOG_BIN.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
