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

Provide MySQL snapshot mode that does not require table locks

    Details

    • Type: Feature Request
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 0.7.2
    • Fix Version/s: 0.7.4
    • Component/s: mysql-connector
    • Labels:
      None
    • Environment:

      MySQL

      Description

      Summary of Concern
      Using the schema_only and schema_only_recovery still requires either setting a global read lock, or locking individual tables, before it reads the schema out. My understanding is that this is to prevent DDL changes to occur at the same time the "snapshot" of the schema is being processed.

      Unfortunately in many high throughput production environments performing locks across entire table(s) is just not a feasible option.

      Proposed Changes
      Create a new snapshot mode (or a configuration option to existing snapshot modes) that allows bypassing the table lock statements. Users could enable this mode/configuration option understanding the risk of overlapped DDL statements could cause issues in properly replicating data.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                spowis Stephen Powis
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: