Stream Compute Service
- Releases Notes and Announcements
- Getting Started
- Operation Guide
- Managing Jobs
- Developing Jobs
- Monitoring Jobs
- Events and Diagnosis
- Managing Metadata
- Tuning Jobs
- Managing Clusters
- Managing Permissions
- SQL Developer Guide
- DDL Statements
- Connectors
- SET Statement
- Operators and Built-in Functions
- Identifiers and Reserved Words
- ETL Developer Guide
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
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. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No