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

Support Amazon RDS (w/ MySQL and Aurora) with MySQL Connector

    Details

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

      Description

      Amazon RDS provides a relational database service using several different DBMS engines, including MySQL and Amazon Aurora. Amazon claims "The Amazon Aurora database engine is fully compatible with MySQL 5.6 using the InnoDB storage engine." However, neither RDS' MySQL or Aurora engines support the FLUSH TABLES WITH READ LOCK statement, and so the current MySQL connector always fails when it gets to this point.

      The MySQL connector should not try to acquire the lock when it is connecting to one of these engines. (Hopefully we can discover we're using one of Amazon's engines by looking at the system variables.) This would potentially impact the consistency of the snapshot – the connector uses these locks because MySQL transactions do not prevent DDL changes, and the lock is the only way to prevent DDL changes while the connector is copying the table schemas. (See DBZ-31 for background on the existing snapshot algorithm.)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                rhauch Randall Hauch
                Reporter:
                rhauch Randall Hauch
              • Votes:
                2 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: