[MDEV-8429] Change binlog_checksum default to match MySQL 5.6.6+ Created: 2015-07-06  Updated: 2016-05-20  Resolved: 2016-05-20

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 5.5.44, 10.0.19
Fix Version/s: 10.2.1

Type: Bug Priority: Major
Reporter: Hartmut Holzgraefe Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Blocks
is blocked by MDEV-8428 Mangled DML statements on 2nd level s... Closed
PartOf
is part of MDEV-7635 update defaults and simplify mysqld c... Closed
Sprint: 10.2.1-3

 Description   

MySQL changed the default for binlig_checksum from NONE to CRC32 between MySQL 5.6.5 and 5.6.6.

MariaDB still has NONE as default though.

This probably happened as the backport to MariaDB happened before MySQL 5.6.6 and the changed default went unnoticed so far?

 Comments   
Comment by Elena Stepanova [ 2015-07-08 ]

I don't think it was an overlook per se, 10.0 has never been claimed to include all 5.6 features, but rather a cherry-picked subset of them.
For 10.1 the subset has been extended, although still not complete.
Particularly for defaults, there is MDEV-6066 that is currently being worked on .

I can't imagine such a change can be backported to 10.0 now, but once again the final decision will not be mine. For now, I'm assigning it to sanja who is working on MDEV-6066.

Comment by Simon J Mudd [ 2015-07-08 ]

Please do not make incompatible changes in 10.0. That's not good.

However, consider adjusting the default behaviour to match MySQL 5.6+ in MariaDB 10.1, as 10.1 is not GA yet.
This simplifies the situation for people who may switch between both systems and expect the configuration to be mostly the same.

Comment by Oleksandr Byelkin [ 2016-05-16 ]

As I can see MariaDB has no such parameter at all, am I right?

Comment by Oleksandr Byelkin [ 2016-05-16 ]

We have slave_sql_verify_checksum and it set to ON by default which effectively equal to binlog_checksum CRC32.
So do we need alias of the parameter or what?

Comment by Oleksandr Byelkin [ 2016-05-16 ]

OK, we have it as a plugin variable of binlog. I found it.

Comment by Oleksandr Byelkin [ 2016-05-16 ]

revision-id: c8a8df7bc925a3991716da04868057eac20f82f1 (mariadb-10.2.0-29-gc8a8df7)
parent(s): b79944950e5e5db40cf7ad49061edf5f105512c4
committer: Oleksandr Byelkin
timestamp: 2016-05-16 16:32:45 +0200
message:

MDEV-8429: Change binlog_checksum default to match MySQL 5.6.6+

—

Comment by Sergei Golubchik [ 2016-05-19 ]

ok to push

Generated at Thu Feb 08 07:27:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.