tencent cloud

Stream Compute Service

Releases Notes and Announcements
Release Notes
Product Introduction
Overview
Strengths
Use Cases
Purchase Guide
Billing Overview
Billing Mode
Refund
Configuration Adjustments
Getting Started
Preparations
Creating a Private Cluster
Creating a SQL Job
Creating a JAR Job
Creating an ETL Job
Creating a Python Job
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
DokumentasiStream Compute ServiceETL Developer GuideConnectorsMySQL Sinks

MySQL Sinks

PDF
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.

Topik sebelumnya: MySQL SourcesTopik selanjutnya: PostgreSQL Sinks

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan