Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7132

Make default value of rocksdb_wal_recovery_mode compatible with InnoDB

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7.x, 8.0.x, Not 5.6.x
    • Fix Version/s: 5.7.31-34, 8.0.21-12
    • Component/s: MyRocks
    • Labels:
      None

      Description

      Currently, after a non-graceful crash MyRocks fails to start. This is because the default value of rocksdb_wal_recovery_mode is 1: "if a WAL entry is corrupted, the server fails to start and does not recover from the crash."

      However, InnoDB by default discards not yet committed transactions. Therefore it is safe to have option 0: "if the last WAL entry is corrupted, truncate the entry and either start the server normally or refuse to start."

      It is also more user-intuitive for those who migrate from InnoDB.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              george.lorch George Lorch
              Reporter:
              sveta.smirnova Sveta Smirnova
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours, 30 minutes
                  3h 30m

                    Smart Checklist