The Ultimate Guide to High Availability with MariaDB

Comments - Migrating from 'innodb' checksum to 'crc32' checksum

9 months, 1 week ago Keshan Nageswaran
Re: Migrating from 'innodb' checksum to 'crc32' checksum

Scenario

If we are migrating from innodb -> crc32/full_crc32 checksum algorithm. Should we execute the checksum validation using innochecksum utility during restore of backup. Note: The backup contains innodb checksum stored and server has crc32 checksum configuration. As I remember, new checksum will only be used/picked up when blocks are modified.

  • Instead of waiting for blocks to be modified over time for the new checksum to be used, how can we rebuild the tables so all blocks gets updated?
  • Should we skip the checksum validation during restore?
 
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.