Static CockroachDB agent

Target CockroachDB

Prerequisites

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

  • Valid user credentials with permission to read, and write to the target tables and respective database;

  • TLS certificate in case of a secure connection;

Setup via Web UI

  • Hostname / IP Address: DNS record or IP Address of your server;

  • Port: Optional, defaults to 26257;

  • Database name: Name of your target database;

  • Username: Username with read/write to database tables;

  • Password: Password belonging to the given username.

Specific configuration

This agent has no specific configuration properties.

Setup via Rest APIs

Here following an example of calling the CoreHub’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": 26257,
        "databaseName": "db_name",
        "username": "",
        "password": "",
        "maxConnectionsCount": 100,
        "enableTls": true,
        "certificatePath": "/myPath/cert.pem"
      }
}'