Feb 042011
Unsafe SQL for MySQL's statement based replication
Answer:
Following are the list of MySQL's function which are unsafe if you are using statement based replication (which is the default in MySQL 5)
In short, if you are using MySQL's replication, do not use the following functions.
- LOAD_FILE()
- UUID(), UUID_SHORT()
- USER()
- FOUND_ROWS()
- SYSDATE()
- GET_LOCK()
- IS_FREE_LOCK()
- IS_USED_LOCK()
- MASTER_POS_WAIT()
- RELEASE_LOCK()
- SLEEP()
- VERSION()
Reference: http://dev.mysql.com/doc/refman/5.1/en/replication-sbr-rbr.html
