Today

MySQL


MySQL

MySQL

Beta version

The configuration and connection might need a bit of fine-tuning to get things running smoothly. Let us know if you hit any snags at team@tably.com.

Once created, a connection can be reused or copy-pasted in all other pages within same workspace without additional setup. The setup can be complex and, if in doubt, ask your developer for help. They will have all needed details and will be able to assist with possible errors.

The host name of the database.
The port to connect to.
The database name.
The username which is used to access the database.
The password associated with the username.
Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). For more information read about JDBC URL parameters.
Encrypt data using SSL.
SSL connection modes. Read more in the docs.

Always connect with SSL. Verifies CA, but allows connection even if Hostname does not match.

CA certificate
Client certificate (this is not a required field, but if you want to use it, you will need to add the Client key as well)
Client key (this is not a required field, but if you want to use it, you will need to add the Client certificate as well)
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.

Always connect with SSL. Verify both CA and Hostname.

CA certificate
Client certificate (this is not a required field, but if you want to use it, you will need to add the Client key as well)
Client key (this is not a required field, but if you want to use it, you will need to add the Client certificate as well)
Password for keystorage. This field is optional. If you do not add it - the password will be generated automatically.
Replication method to use for extracting data from the database.

CDC uses the Binlog to detect inserts, updates, and deletes. This needs to be configured on the source database itself.

The amount of time the connector will wait when it launches to determine if there is new data to sync or not. Defaults to 300 seconds. Valid range: 120 seconds to 1200 seconds. Read about initial waiting time.
Enter the configured MySQL server timezone. This should only be done if the configured timezone in your MySQL instance does not conform to IANNA standard.
Whether to initiate an SSH tunnel before connecting to the database, and if so, which kind of authentication to use.
Hostname of the jump server host that allows inbound ssh tunnel.
Port on the proxy/jump server that accepts inbound ssh connections.
OS-level username for logging into the jump server host.
OS-level user account ssh key credentials in RSA PEM format ( created with ssh-keygen -t rsa -m PEM -f myuser_rsa )
Hostname of the jump server host that allows inbound ssh tunnel.
Port on the proxy/jump server that accepts inbound ssh connections.
OS-level username for logging into the jump server host
OS-level password for logging into the jump server host
Finish step configuration to see output