Which binary log format is safest for replication involving non-deterministic functions?
- A STATEMENT
- B ROW
- C MIXED
- D TEXT
Answer
ROW
ROW logs the actual data changes, so functions like NOW() or UUID() replicate correctly. STATEMENT logs the SQL and can diverge between source and replica.





