Releases Notes and Announcements
- Release Notes
Product Introduction
Purchase Guide
Getting Started
Operation Guide
- Managing Jobs
- Developing Jobs
- Monitoring Jobs
- Job Logs
- Events and Diagnosis
- Managing Metadata
- Managing Checkpoints
- Tuning Jobs
- Managing Dependencies
- Managing Clusters
- Managing Permissions
SQL Developer Guide
- Overview
- Glossary and Data Types
- DDL Statements
- DML Statements
- Merging MySQL CDC Sources
- Connectors
- SET Statement
- Operators and Built-in Functions
- Identifiers and Reserved Words
Python Developer Guide
ETL Developer Guide
- Overview
- Glossary
- Connectors
FAQ
Contact Us

MySQL Sinks

Mode fokus

Ukuran font

Terakhir diperbarui: 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.
﻿

Bantuan dan Dukungan

Apakah halaman ini membantu?

Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.

masukan

tencent cloud

Stream Compute Service

MySQL Sinks

Overview

Notes

Primary key

WITH parameters

Bantuan dan Dukungan

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.