Back to source list
Official
Premium
MySQL
The CloudQuery MySQL plugin syncs your MySQL database to any of the supported CloudQuery destinations
Loading plugin documentation
The CloudQuery MySQL plugin syncs your MySQL database to any of the supported CloudQuery destinations
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: source
spec:
name: mysql
path: cloudquery/mysql
registry: cloudquery
version: "v4.6.5"
tables: ["*"]
destinations: ["postgresql"]
# Learn more about the configuration options at https://cql.ink/mysql_source
spec:
connection_string: "user:password@/dbname"
# Optional parameters
# rows_per_record: 500
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 TLSrows_per_record (integer) (optional) (default: 500)incremental_column (string) (optional)incremental_column specified in the table_options section of the configuration. The tables without an incremental_column will be synced fully.incremental_column in the table_options section of the configuration. Here's an example source spec to sync a list of tables incrementally:kind: source
spec:
name: mysql
path: cloudquery/mysql
registry: cloudquery
version: "v4.6.5"
tables:
- "my_table"
- "another_table"
- "yet_another_table"
destinations: ["postgresql"]
backend_options:
table_name: "cq_state_bq"
connection: "@@plugins.postgresql.connection"
spec:
connection_string: "user:password@/dbname"
# Optional parameters
# rows_per_record: 500
table_options:
my_table:
incremental_column: updated_at
another_table:
incremental_column: id
my_table table will be synced incrementally based on the updated_at column. another_table will be synced incrementally based on the id column. yet_another_table will be synced fully.cq_state_bq table in the PostgreSQL destination.