The Mysql replication generally works very well. There are some things however, which can create a different result on the master than on the slave.
Which features are not replication safe? Assume MySQL >= 5.0.13
(Find all correct answers)
a) NOW() b) UUID() c) SYSDATE() d) SET @my_uuid = UUID(); INSERT INTO t VALUES(@my_uuid);
[ Scaling MySQL (10%) - Replication ]
b and c can/will create different results on the slave than on the master.
But a and d will work fine.
See http://dev.mysql.com/doc/refman/5.0/en/replication-features-functions.html