tencent cloud

Feedback

MySQL Sinks

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.
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support