Evaluation of Table-opracowanie

Nasza ocena:

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

Pobierz ten dokument za darmo

Podgląd dokumentu
Evaluation of Table-opracowanie - strona 1

Fragment notatki:

Evaluation of Table-Level Replication Options
The slave checks for and evaluates table options only if no matching database options were found (see
Section 16.2.3.1, “Evaluation of Database-Level Replication and Binary Logging Options”).
First, as a preliminary condition, the slave checks whether statement-based replication is enabled.
If so, and the statement occurs within a stored function, the slave executes the statement and exits.
If row-based replication is enabled, the slave does not know whether a statement occurred within a
stored function on the master, so this condition does not apply.
Having reached this point, if there are no table options, the slave simply executes all events. If there
are any --replicate-do-table [2012] or --replicate-wild-do-table [2014] options,
the event must match one of these if it is to be executed; otherwise, it is ignored. If there are any --
replicate-ignore-table [2013] or --replicate-wild-ignore-table [2014] options, all
events are executed except those that match any of these options. This process is illustrated in the
following diagram.
... zobacz całą notatkę



Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz