tencent cloud

Stream Compute Service

MySQL Sinks

PDF
Focus Mode
Font Size
Last updated: 2023-11-08 16:19:33

Overview

A MySQL data sink can write data to the MySQL database.

Notes

Primary key

All data generated by an ETL data source table is UPSERT data, so it's important that you correctly define the primary key for the MySQL database table.

WITH parameters

MySQL data sinks are developed based on JDBC and support the following sink-related configurations:
Parameter
Required
Default Value
Description
sink.buffer-flush.max-rows
No
100
The maximum size of buffered records before flush. If this is set to 0, data will not be buffered.
sink.buffer-flush.interval
No
1s
‍The maximum interval (ms) between ‍flushes. If sink.buffer-flush.max-rows is 0, and this parameter is not, buffered actions will be processed asynchronously.
sink.max-retries
No
3
The maximum number of retries allowed when a write operation fails.


Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback