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

포커스 모드

폰트 크기

마지막 업데이트 시간: 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.
﻿

도움말 및 지원

문제 해결에 도움이 되었나요?

더 자세한 내용은 문의하기 또는 티겟 제출 을 통해 문의할 수 있습니다.

피드백

tencent cloud

Stream Compute Service

MySQL Sinks

Overview

Notes

Primary key

WITH parameters

도움말 및 지원

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.