A MySQL binlog reader reads data from tables in your MySQL database in real time based on a real-time binlog subscription.

Create a MySQL binlog reader

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. On the Workspaces page, find the target workspace and click Data Analytics in the Actions column.
  2. On the Data Analytics tab, move the pointer over the Create a sync node icon and choose Data Integration > Real-Time Sync.

    You can also find the target workflow, right-click Data Integration, and choose Create > Real-Time Sync.

  3. In the Create Node dialog box that appears, set Node Name and Location, and then click Commit.
  4. On the configuration tab of the real-time sync node, drag MySQL Binlog under Reader to the editing panel.
  5. Click the MySQL Binlog node and set parameters in the Node Settings section.
    Parameter Description
    Connection The connection to the MySQL binlog data store. In this example, you can only select a MySQL binlog connection.

    If no connection is available, click Add Connection on the right to create one on the Workspace Manage > Data Source page.

    Table The name of the table from which data is read in the MySQL database. You can click Preview on the right to preview the selected table.
    Start Offset The start time of the sync node.
    Time Zone The time zone where the MySQL database resides.
    Output Fields The fields from which data is read.
  6. Click Save the settings in the toolbar.