Comments - Migrating from 'innodb' checksum to 'crc32' checksum
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Thank you for this Marko. The solutions provided are of real help for us. One last question, does the
innodchecksumutility supportfull_crc32validation?"and then start the server with
innodb_checksum_algorithm=strict_full_crc32so that new files will be created in the full_crc32 format, and for any old-format files only the crc32 page checksums will be allowed."In my understanding from the above statement, I believe we would end up having mix of crc32(old pages) and full_crc32(new pages), will this cause any issues during checksum validation with
innodchecksumutility?No,
innochecksumdoes not fully supportfull_crc32- see MDEV-26907. Ifinnochecksumis a required part of your workflow, you could stick withcrc32.Noted and Thank you Ian!