Skip to main content

2.12 MySQL Sink Connector

Create a connector where Type is sink and Database is MySQL

Pre-condition: CDC service status is healthy

Steps to create a connector:​

Step 1: In the menu bar, select Data Platform > select Workspace Management > select Workspace name

Step 2: In the My services section, select CDC service

Step 3: On the CDC service detail screen > select the Connectors tab > click Create a connector

image-1

Step 4: Enter the information on the Connector Information screen:

  • Name (required): connector name

Note: The connector name can contain lowercase letters a-z or digits 0-9. In particular, spaces are not allowed — you can replace spaces with "-".

  • Type (required): select sink
  • Database (required): select MySQL

image-2

Step 5. Click Next to proceed to the Properties screen

Enter the information on the Properties screen

  • If you select Manual configuration - fill in the following information:
    • Host Name (required): Hostname or IP of MySQL
    • Port (required): MySQL server port, default: 3306.
    • Database name (required): The target database that the Connector will sink data into
    • Username (required): Username used by the Connector
    • Password (required): Password used by the Connector

image-3

  • If you select From Database Engine - fill in the following information:
    • Database name (required): Database name
    • Host Name (required): Hostname or IP of MySQL
    • Port (required): MySQL server port, default: 3306.
    • Database name (required): The target database that the Connector will sink data into
    • Username (required): Username used by the Connector
    • Password (required): Password used by the Connector

image-4

Click Test connection to verify the connection from the Workspace to the entered Database

  • Converter
    • Converter key: select the key value for the converter
    • Converter key schema enable: select whether or not to use a schema in the Converter key
    • Converter value: select the value for the converter
    • Converter value schema enable: select whether or not to use a schema in the Converter value

image-5

  • Topics (required): The list of topics the Connector will consume and sink data into the target database, separated by ","

image-6

Step 6: Click Next to proceed to the Additional Properties screen

Enter the following information:

  • Timezone: select the appropriate timezone for the data from the source database

image-7

  • Type: select the source Database type

image-8

  • Task max: the number of tasks processing together

image-9

  • Map Table:
    • Topic 1: The topic name to listen to from the source connector
    • Table 1: The table name to listen for data changes from the source connector

image-10

  • Mode (required): The Connector's behavior when a message cannot be processed
    • None: The Connector will skip messages that cannot be sinked into the database
    • All: Failed messages will be sent to the specified topic

image-11

Step 7. Click Next to proceed to the Review screen

image-12

Step 8: Review the information and click the Create button to finish creating the connector