Skip to content

Question 72: Which features are not replication safe?

19. June 2010
By plogi in mysql questions

1 Comment

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 ]

Tags: , ,

Comment Feed

One Response

  1. plogi — 19. June 2010 @ 20:30:54 —


    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

You must be logged in to post a comment.