Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8429

Change binlog_checksum default to match MySQL 5.6.6+

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.19, 5.5.44
        • Fix Version/s: 10.1
        • Component/s: Replication
        • Labels:
          None

          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?

            Gliffy Diagrams

              Attachments

                Issue Links

                is blocked by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8428 Mangled DML statements on 2nd level slave when enabling binlog checksums

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  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 Oleksandr Byelkin who is working on MDEV-6066.

                  Show
                  elenst Elena Stepanova added a comment - 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 Oleksandr Byelkin who is working on MDEV-6066 .
                  Hide
                  Permalink
                  simon.mudd Simon J Mudd added a comment -

                  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.

                  Show
                  simon.mudd Simon J Mudd added a comment - 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.

                    People

                    • Assignee:
                      sanja Oleksandr Byelkin
                      Reporter:
                      hholzgra Hartmut Holzgraefe
                    • Votes:
                      1 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated: