Comments on: “Anemomaster”: DML visibility. Your must-do for tomorrow https://shlomi-noach.github.io/blog/mysql/anemomaster-dml-visibility-your-must-do-for-tomorrow Blog by Shlomi Noach Mon, 26 Jan 2015 15:50:55 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Reading RBR binary logs with pt-query-digest | code.openark.org https://shlomi-noach.github.io/blog/mysql/anemomaster-dml-visibility-your-must-do-for-tomorrow/comment-page-1#comment-306231 Mon, 26 Jan 2015 15:50:55 +0000 https://shlomi-noach.github.io/blog/?p=6793#comment-306231 […] "Anemomaster": DML visibility. Your must-do for tomorrow […]

]]> By: CEPE.sql https://shlomi-noach.github.io/blog/mysql/anemomaster-dml-visibility-your-must-do-for-tomorrow/comment-page-1#comment-238518 Wed, 23 Apr 2014 20:51:23 +0000 https://shlomi-noach.github.io/blog/?p=6793#comment-238518 Great, I’m not alone!
Thanks for sharing.
Bye

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/anemomaster-dml-visibility-your-must-do-for-tomorrow/comment-page-1#comment-238485 Wed, 23 Apr 2014 14:41:33 +0000 https://shlomi-noach.github.io/blog/?p=6793#comment-238485 Hi Cédric,

1. Correct. This currently works only on STATEMENT based replication. I’m writing a script which transforms a ROW binlog into STATEMENT-like binlog (via mysqlbinlog –verbose). We are using STATEMENT most of the time, ourselves, and so I’m not in pressure to do so…

2. Possible; haven’t noticed. Will take a further look

3. I’m exhausted on 5.6 evaluation, and am taking a rest. I don’t know.

]]> By: CEPE.sql https://shlomi-noach.github.io/blog/mysql/anemomaster-dml-visibility-your-must-do-for-tomorrow/comment-page-1#comment-238482 Wed, 23 Apr 2014 14:16:40 +0000 https://shlomi-noach.github.io/blog/?p=6793#comment-238482 Hi Shlomi, thx for that.

I tried myself to include relay logs informations in anemometer but I encountered 3 problems :
– MIXED or RAW replication could be a problem
– With MySQL 5.5 (percona server), LOAD DATA INFILE could be a problem with pt-query-digest and type=binlog (need to update the script)
– With MySQL 5.6 (percona server), pt-query-digest and type=logbin didn’t work as expected

Could you explain details on your environnement and explain if you fell on these issues?

]]> By: Monitoring DML/slow queries with graphite | code.openark.org https://shlomi-noach.github.io/blog/mysql/anemomaster-dml-visibility-your-must-do-for-tomorrow/comment-page-1#comment-238113 Sat, 19 Apr 2014 05:59:33 +0000 https://shlomi-noach.github.io/blog/?p=6793#comment-238113 […] "Anemomaster": DML visibility. Your must-do for tomorrow […]

]]>