Back to plugin list
Official
Premium
MySQL
The CloudQuery MySQL plugin syncs your MySQL database to any of the supported CloudQuery destinations
Publisher
cloudquery
Latest version
v4.3.6
Type
Source
Platforms
Date Published
Price per 1M rows
Starting from $15
monthly free quota
1M rows
Set up process #
brew install cloudquery/tap/cloudquery
1. Download CLI and login
2. Create source and destination configs
Plugin configurationOverview #
The CloudQuery MySQL plugin syncs your MySQL database to any of the supported CloudQuery destinations (e.g. PostgreSQL, BigQuery, Snowflake, and more).
Supported database versions are >= 8.0.
If you need support for older versions, please contact us
Example Configuration #
kind: source
spec:
name: mysql
path: cloudquery/mysql
registry: cloudquery
version: "v4.3.6"
tables: ["*"]
destinations: ["postgresql"]
spec:
connection_string: "user:password@/dbname"
# Optional parameters
# rows_per_record: 500
Configuration Reference #
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 for more details."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 TLS
rows_per_record
(integer
) (optional) (default:500
)Amount of rows to be packed into a single Apache Arrow record to be sent over the wire during sync.