Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-652

Evaluate snapshot.locking.mode=none for tables set with MyISAM engine

    XMLWordPrintable

Details

    Description

      The snapshot.locking.mode=none should ideally not hold any locks against tables/dbs while performing a snapshot.This works correctly when innoDB(since it has row-level locking) is the engine for the table meaning, while a snapshot is being performed, inserts/updates can happen on the same table . However, MyISAM engine tends to hold table level locks the result of which is that when snapshot is being performed, no updates/inserts can be made.

      This basically negates the usage of the snapshot.locking.mode value set to none for MyISAM engine tables as what we desire is no locks should be held.

      This behavior should be explored more and if no other alternatives can be found, then the documentation should be updated.

      Attachments

        Activity

          People

            Unassigned Unassigned
            vamossagar12 Sagar Rao (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: