Target MySQL

Prerequisites

To have Gluesync working on your MySQL instance you will need to have:

Valid user credentials with permission to read, and write to the target tables.

Setup via Web UI

Hostname / IP Address: DNS record or IP Address of your server;
Port: Optional, defaults to 3306;
Database name: Name of your database;
Username: Username with read/write access to the tables;
Password: Password belonging to the given username;
Max connections count: Maximum number of connections the pool can instantiate;
Enable TLS: Optional, defaults to false;
Certificate path: Optional, path to the certificate file.

Setup under AWS RDS / DBaaS

AWS RDS, like any other DBaaS, allows database connections only via SSL. Flag Use SSL to true during the agent’s setup phase.

Specific configuration

This agent has no specific configuration properties.

Setup via Rest APIs

Here following an example of calling the Core Hub’s Rest API via curl to setup the connection for this Agent.

Connect the agent

curl --location --request PUT 'http://core-hub-ip-address:1717/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
        "hostCredentials": {
        "connectionName": "myAgentNickName",
        "host": "host-address",
        "port": 3306,
        "databaseName": "db_name",
        "username": "",
        "password": "",
        "maxConnectionsCount": 100,
        "enableTls": true,
        "certificatePath": "/myPath/cert.pem"
      }
}'