Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 72: Which features are not replication safe? – MySQL Question of the Day

Skip to content

By plogi in mysql questions

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. plogi19. 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.