Determination of Safe and Unsafe Statements in Binary Logging-opracowanie

Determination of Safe and Unsafe Statements in Binary Logging
When speaking of the “safeness” of a statement in MySQL Replication, we are referring to whether a
statement and its effects can be replicated correctly using statement-based format. If this is true of the
statement, we refer to the statement as safe; otherwise, we refer to it as unsafe.
In general, a statement is safe if it deterministic, and unsafe if it is not. However, certain
nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered
unsafe, later in this section). In addition, statements using results from floating-point math functions—
which are hardware-dependent—are always considered safe (see Section 16.4.1.12, “Replication and
Floating-Point Values”).
... zobacz całą notatkę