Replication and Views-opracowanie

Nasza ocena:

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

Pobierz ten dokument za darmo

Podgląd dokumentu
Replication and Views-opracowanie - strona 1

Fragment notatki:

Replication and Views
Views are always replicated to slaves. Views are filtered by their own name, not by the tables they refer
to. This means that a view can be replicated to the slave even if the view contains a table that would
normally be filtered out by replication-ignore-table rules. Care should therefore be taken to
ensure that views do not replicate table data that would normally be filtered for security reasons.
Replication from a table to a samed-named view is supported using statement-based logging, but not
when using row-based logging. In MySQL 5.6.11 and later, trying to do so when row-based logging is
in effect causes an error. (Bug #11752707, Bug #43975)
... zobacz całą notatkę



Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz