Replication and System Functions-opracowanie

Replication and System Functions
Certain functions do not replicate well under some conditions:
• The USER() [1293], CURRENT_USER() [1287] (or CURRENT_USER [1287]), UUID() [1300],
VERSION() [1293], and LOAD_FILE() [1201] functions are replicated without change and thus
do not work reliably on the slave unless row-based replication is enabled. (See Section 16.1.2,
“Replication Formats”.)
USER() [1293] and CURRENT_USER() [1287] are automatically replicated using row-based
replication when using MIXED mode, and generate a warning in STATEMENT mode. (See also
Section 16.4.1.7, “Replication of CURRENT_USER()”.) This is also true for VERSION() [1293] and
RAND() [1226].
... zobacz całą notatkę