Re: Reply to this. You know what to say ........

Sinisa Milivojevic wrote:
>
> ------------------------------------------------------------ ------------
>
> Subject:
> insert into non-replicated database from replicated database breaks
> replication
> From:
> Mike Johnson
> Date:
> Tue, 28 Jan 2003 11:14:45 -0500
> To:
> bugs@lists.mysql.com
>
>
>>Description:
>
> When working in a replicated database, on the master server,
> inserts or updates to non-replicated databases causes the
> replication slave(s) to break replication, due to the
> referenced non-replicated database not being found.

This is only possible correct behaviour. See below.

>
>>How-To-Repeat:
>
> In a replicated environment, enter the console on the master
> server. USE a replicated database. Then perform an INSERT on
> a non-replicated database table (referenced as
> unreplicated_database.table).
>
>>Fix:
>
> Replication should eventually be able to ignore this query, not
> blindly replicate it just because the current database being used
> replicates.

"Replicated environment" is specific as it depends on options you use.

You can for example enable only single table to be replicated, but in such case it
is your responcibility to construct queries in a way that they update your table
independantly ofther tables. Replication can't help you as it does not deal with
data - It only makes sure same queries will be executed on both Master and Slave.

If you have some databases or tables non-replicated you can always construct query
which Slave can't replicate like:

INSERT INTO replicated_table SELECT .. FROM non-replicated_table;

Slave is unable to execute this query as it refers nonexisting table (non-replicated).

Everything up to this point is as you said.

But in such case Slave can't silently skip query and continue as replicated table
will become in inconsistant state.
At this point Slave knows that Table on Master get's aditional rows, but Slave is
unable to repeat this action. Replication is broken.


Best regards

--
MySQL Conference and Expo 2003 http://www.mysql.com/events/uc2003/index.html
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com




------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13621@lists.mysql.com
To unsubscribe, e-mail