Filtering based on server ID not supported-opracowanie

Filtering based on server ID not supported. A common practice is to filter out changes on
some slaves by using a WHERE clause that includes the relation @@server_id id_value
clause with UPDATE and DELETE statements, a simple example of such a clause being WHERE
@@server_id 1. However, this does not work correctly with row-based logging. If you
must use the server_id [551] system variable for statement filtering, you must also use --
binlog_format=STATEMENT [2047].
In MySQL 5.6, you can do filtering based on server ID by using the IGNORE_SERVER_IDS option
for the CHANGE MASTER TO statement. This option works with the statement-based and row-based
logging formats.
... zobacz całą notatkę