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

Allow mysql-connector to replicate from replica that doesn't have MASTER STATUS

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Won't Do
    • Major
    • None
    • None
    • mysql-connector
    • None

    Description

      We are currently using mysql-connector for our on-premise MySQL. Recently there's an effort of migrating the on-prem MySQL to Aurora.

      During the migration we realized that if we point the mysql-connector to Aurora replica, it won't be able to retrieve GTID set, because that process has dependency on the following query:

      mysql> SHOW MASTER STATUS;
      Empty set (0.21 sec) 

      This seems to be something that we can't bypass on Aurora. To enable replicating from a Aurora replica, we can add a fallback mechanism to the code where SHOW MASTER STATUS is called. 

      I believe SHOW SLAVE STATUS could provide equivalent information in this case, the relevant fields are 

      Relay_Master_Log_File

      Exec_Master_Log_Pos

      Executed_Gtid_Set

      Attachments

        Activity

          People

            Unassigned Unassigned
            boquan.t Boquan Tang (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: