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

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

XMLWordPrintable

      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.

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

                Created:
                Updated: