Bug #56573 mtr has to run with --binlog-checksum=CRC32 (replication checksum enabled)
Submitted: 5 Sep 2010 17:56 Modified: 30 Nov 2010 22:21
Reporter: Andrei Elkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:5.6+ OS:Any
Assigned to: Luis Soares CPU Architecture:Any
Tags: replication checksum

[5 Sep 2010 17:56] Andrei Elkin 
Description:
mtr does not set up replication-checksum-aware servers with 
--binlog-checksum=CRC32.
This has to be done in order to verify correctness or the new feature implementation on PB2 as well.

For triaging please level this actual feature request priority to the one of
WL#2540.

How to repeat:
currently mtr does not have any option dealing with the replication checksum.

Suggested fix:
1. to make mtr to prepare the startup parameters with --binlog-checksum=CRC32 by default and 
2. to provide a new option to disable checksum for the started server.
[12 Oct 2010 20:58] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/120601

3180 Serge Kozlov	2010-10-13
      Bug#56573. MTR will add automatically the option --binlog-checksum=CRC32 for MySQL servers of rpl/binlog suites if a tree support checksums.
      New MTR option --disable-binlog-checksum restores old behavior of MTR (w/o checksum even server supports it).
      The algorithm of checksum can be overriden via --mysqld=--binlog-format
[15 Oct 2010 19:13] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/120873

3180 Serge Kozlov	2010-10-15
      Bug#56573 Adding binlog checksum testing for binlog,rpl suites.
      For reduce turnaround times only 10% of randomly chosen tests runs from these suites  in PB2 per push.
[27 Oct 2010 10:03] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/122062

3185 Serge Kozlov	2010-10-27
      Bug#56573. Adding binlog checksum testing for binlog,rpl suites. For reduce turnaround times only 10% of randomly chosen tests runs from these suites  in PB2 per push.
[27 Oct 2010 10:47] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/122072

3186 Serge Kozlov	2010-10-27
      Bug#56573. Adding binlog checksum testing for binlog,rpl suites. For reduce turnaround times only 10% of randomly chosen tests runs from these suites  in PB2 per push.
[16 Nov 2010 11:35] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/124021

3200 Luis Soares	2010-11-16
      BUG#56573: mtr has to run with --binlog-checksum=CRC32 (replication 
                 checksum enabled)
      
      Adding collections to run mysql-trunk.daily and
      mysql-trunk.weekly.  Both are a copy of the respective default.*
      collection, excpet that they have one extra mtr run with
      checksums enabled:
      
        - daily: suite=binlog,rpl
        - weekly: suite=main,binlog,innodb,federated,rpl,sys_vars,perfschema
[29 Nov 2010 11:11] Bugs System 
Pushed into mysql-trunk 5.6.1-m5 (revid:alexander.nozdrin@oracle.com-20101129111021-874if2qsp0i8d5ze) (version source revid:alexander.nozdrin@oracle.com-20101129111021-874if2qsp0i8d5ze) (merge vers: 5.6.1-m5) (pib:23)
[30 Nov 2010 22:21] Jon Stephens 
Does not appear in a release; no changelog entry required.

Closed.