This destination plugin lets you sync data from a CloudQuery source to any MySQL-compatible database, including Amazon RDS for MySQL and MariaDB.
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
If you need support for older versions, please contact us
kind: destination
spec:
name: "mysql"
path: "cloudquery/mysql"
registry: "cloudquery"
version: "v5.5.2"
# Learn more about the configuration options at https://cql.ink/mysql_destination
spec:
connection_string: "user:password@/dbname"
# Optional parameters:
# batch_size: 1000 # 1K entries
# batch_size_bytes: 4194304 # 4 MiB
batch_size and batch_size_bytes.connection_string (string) (required)"user:password@tcp(127.0.0.1:3306)/dbname" connect with TCP"user:[email protected]:3306/dbname?charset=utf8mb4\u0026parseTime=True\u0026loc=Local" connect and set character set, time parsing, and location"user:password@localhost:3306/dbname?timeout=30s\u0026readTimeout=1s\u0026writeTimeout=1s" connect and set various timeouts"user:password@/dbname?loc=UTC\u0026allowNativePasswords=true\u0026tls=preferred" connect and set location and native password allowance, and prefer TLSbatch_size (integer) (optional) (default: 1000)batch_size_bytes (integer) (optional) (default: 4194304 (= 4 MiB))docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=test -e MYSQL_DATABASE=cloudquery -d mysql:latest
cloudquery MySQL database via the following connection string:root:password@/cloudquery
kind: destination
spec:
name: "mysql"
path: "cloudquery/mysql"
registry: "cloudquery"
version: "v5.5.2"
spec:
connection_string: "root:password@/cloudquery"
tinyint(1) to align with MySQL's information schema representationdatetime(6)text for maximum compatibility