Filtering based on server ID not supported-opracowanie

Nasza ocena:

3
Wyświetleń: 273
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
Filtering based on server ID not supported-opracowanie - strona 1

Fragment notatki:

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ę

Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz