MySQL 5.1 Reference Manual  /  ...  /  Determination of Safe and Unsafe Statements in Binary Logging 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 unsafe (see Section, “Replication and Floating-Point Values”).

Handling of safe and unsafe statements. A statement is treated differently depending on whether the statement is considered safe, and with respect to the binary logging format (that is, the current value of binlog_format).

  • No distinction is made in the treatment of safe and unsafe statements when the binary logging mode is ROW.

  • If the binary logging format is MIXED, statements flagged as unsafe are logged using the row-based format; statements regarded as safe are logged using the statement-based format.

  • If the binary logging format is STATEMENT, statements flagged as being unsafe generate a warning to this effect. (Safe statements are logged normally.)

For more information, see Section 16.1.2, “Replication Formats”.

Statements considered unsafe. Statements having the following characteristics are considered unsafe:

For additional information, see Section 16.4.1, “Replication Features and Issues”.

Download this Manual
User Comments
Sign Up Login You must be logged in to post a comment.