Comments on: Making UUID() and RAND() replication safe https://shlomi-noach.github.io/blog/mysql/making-uuid-and-rand-replication-safe Blog by Shlomi Noach Wed, 22 Oct 2014 05:29:01 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Pseudo GTID | code.openark.org https://shlomi-noach.github.io/blog/mysql/making-uuid-and-rand-replication-safe/comment-page-1#comment-283072 Wed, 22 Oct 2014 05:29:01 +0000 https://shlomi-noach.github.io/blog/?p=7034#comment-283072 […] Making UUID() and RAND() replication safe […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/making-uuid-and-rand-replication-safe/comment-page-1#comment-282618 Mon, 20 Oct 2014 14:23:52 +0000 https://shlomi-noach.github.io/blog/?p=7034#comment-282618 Daniel, if the slaves are replicating via STATEMENT based replication, and have log_slave_updates, then replication on those slaves will fail.

]]> By: Daniël van Eeden https://shlomi-noach.github.io/blog/mysql/making-uuid-and-rand-replication-safe/comment-page-1#comment-282611 Mon, 20 Oct 2014 14:16:26 +0000 https://shlomi-noach.github.io/blog/?p=7034#comment-282611 It reminds me of the similar method which can be used for password() so that it doesn’t put the cleartext password in the binlog.

Why would you do this and not set the binlog_format to MIXED (or ROW) for the server or session?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/making-uuid-and-rand-replication-safe/comment-page-1#comment-282490 Mon, 20 Oct 2014 08:54:33 +0000 https://shlomi-noach.github.io/blog/?p=7034#comment-282490 @ik_5, please follow the UUID() link in text to find out what version is used.

]]> By: ik_5 https://shlomi-noach.github.io/blog/mysql/making-uuid-and-rand-replication-safe/comment-page-1#comment-282472 Mon, 20 Oct 2014 07:30:59 +0000 https://shlomi-noach.github.io/blog/?p=7034#comment-282472 What UUID version is used in MySQL function ?

There are several versions for it, each one uses something a bit different.

http://en.wikipedia.org/wiki/Universally_unique_identifier#Variants_and_versions

]]>