MySQL destination plugin configuration reference
Latest: v4.0.2Example Configuration
kind: destination
spec:
name: "mysql"
registry: "github"
path: "cloudquery/mysql"
version: "v4.0.2"
spec:
connection_string: "user:password@/dbname"
# Optional parameters:
# batch_size: 1000 # 1K entries
# batch_size_bytes: 4194304 # 4 MiB
Make sure you use environment variable expansion in production instead of committing the credentials to the configuration file directly.
The MySQL destination utilizes batching, and supports batch_size
and batch_size_bytes
.
MySQL spec
This is the (nested) spec used by the MySQL destination plugin.
-
connection_string
(string
) (required)Connection string to connect to the database. See the Go driver documentation (opens in a new tab) for more details.
-
batch_size
(integer
) (optional) (default:1000
)This parameter controls the maximum amount of items may be grouped together to be written as a single write.
-
batch_size_bytes
(integer
) (optional) (default:4194304
(= 4 MiB))This parameter controls the maximum size of items that may be grouped together to be written as a single write.