89316

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 generał, a statement is safe if it deterministic, and unsafe if it is not. However, certa i n

nondeterministic functionsare 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—arealways considered safe (see Section 16.4.1.12, "Replication and Floating-Point Values").