Getting Detailed Information
Detailed information about the individual nodes, datasources and services within the dataservice can be obtained by using the hierarchical structure
of the dataservice as presented through cctrl . By using the ls -l command-line option detailed information
can be obtained about any object. For example, getting the detailed listing of a specific host produces the following:
[LOGICAL] /alpha > ls -l db2
COORDINATOR[db2:AUTOMATIC:ONLINE]
ROUTERS:
+---------------------------------------------------------------------------------+
|connector@db1[74034](ONLINE, created=4, active=0) |
|connector@db2[75837](ONLINE, created=8, active=0) |
|connector@db3[76888](ONLINE, created=4, active=0) |
+---------------------------------------------------------------------------------+
DATASOURCES:
+---------------------------------------------------------------------------------+
|db2(slave:ONLINE, progress=3, latency=267.323) |
|STATUS [OK] [2025/01/24 01:26:24 PM UTC] |
+---------------------------------------------------------------------------------+
| activeConnectionCount: 0 |
| alertMessage: |
| alertStatus: OK |
| alertTime: 1737725184632 |
| appliedLatency: 267.323 |
|callableStatementsCreatedCount: 0 |
| connectionsCreatedCount: 0 |
| dataServerHost: db2 |
| dataServiceName: alpha |
| datasourceGroupId: 0 |
| driver: org.drizzle.jdbc.DrizzleDriver |
| highWater: 0(mysql-bin.000019:0000000000000625;10516) |
| host: db2 |
| isArchive: false |
| isAvailable: true |
| isComposite: false |
| isSubService: false |
| lastError: |
| lastShunReason: |
| masterConnectUri: thl://db1:2112/ |
| name: db2 |
|preparedStatementsCreatedCount: 0 |
| relativeLatency: 276.085 |
| role: slave |
| sequence: Sequence(0:0) |
| state: ONLINE |
| statementsCreatedCount: 0 |
|url: |
|jdbc:mysql:thin://db2:13306/${DBNAME}?jdbcCompliantTruncation=false&zeroDateT |
|imeBehavior=convertToNull&tinyInt1isBit=false&allowMultiQueries=true&yearIsDa |
|teType=false |
| useSSL: false |
| vendor: mysql |
| vipAddress: |
| vipInterface: |
| vipIsBound: false |
+---------------------------------------------------------------------------------+
+---------------------------------------------------------------------------------+
|db2:REPLICATOR(role=slave, state=ONLINE) |
+---------------------------------------------------------------------------------+
| appliedLastEventId: mysql-bin.000019:0000000000002023;11970 |
| appliedLastGoodLatency: 267.323 |
| appliedLastGoodSeqno: 3 |
| appliedLastSeqno: 3 |
| appliedLatency: 267.323 |
| autoRecoveryEnabled: false |
| autoRecoveryTotal: 0 |
| channels: 1 |
| clusterName: alpha |
| currentEventId: NONE |
| currentTimeMillis: 1737726516085 |
| dataServerHost: db2 |
| extensions: |
| host: db2 |
| latestEpochNumber: 2 |
| masterConnectUri: thl://db1:2112/ |
| masterListenUri: thl://db2:2112/ |
| maximumStoredSeqNo: 3 |
| minimumStoredSeqNo: 0 |
| notificationSource: TungstenReplicatorOSSChecker:connected |
| offlineRequests: NONE |
| pendingError: NONE |
| pendingErrorCode: NONE |
| pendingErrorEventId: NONE |
| pendingErrorSeqno: -1 |
| pendingExceptionMessage: NONE |
| pipelineSource: thl://db1:2112/ |
| relativeLatency: 276.085 |
| resourceJdbcDriver: org.drizzle.jdbc.DrizzleDriver |
|resourceJdbcUrl: |
|jdbc:mysql:thin://db2:13306/${DBNAME}?jdbcCompliantTruncation=false&zeroDateT |
|imeBehavior=convertToNull&tinyInt1isBit=false&allowMultiQueries=true&yearIsDa |
|teType=false |
| resourceVendor: mysql |
| rmiPort: 10000 |
| role: slave |
| seqnoType: java.lang.Long |
| serviceName: alpha |
| serviceType: local |
| simpleServiceName: alpha |
| siteName: default |
| sourceId: db2 |
| state: ONLINE |
| timeInStateSeconds: 8.814 |
| timezone: GMT |
| transitioningTo: |
| uptimeSeconds: 336.638 |
| useSSLConnection: false |
| version: Tungsten Replicator 8.0.4 Build 132 |
| vipAddress: |
| vipInterface: |
+---------------------------------------------------------------------------------+
+---------------------------------------------------------------------------------+
|db2:DATASERVER(state=ONLINE) |
+---------------------------------------------------------------------------------+
| Binlog_Do_DB: |
| Binlog_Ignore_DB: |
| Executed_Gtid_Set: |
| File: mysql-bin.000011 |
| Position: 157 |
| applied_latency: 267 |
| epoch_number: 2 |
| eventid: mysql-bin.000019:0000000000002023;11970 |
| extract_timestamp: 1737726240000 |
| fragno: 0 |
| is_read_only: 1 |
| last_frag: 1 |
| relative_latency: 275 |
| seqno: 3 |
| shard_id: tungsten_alpha |
| source_id: db1 |
| task_id: 0 |
| update_timestamp: 1737726507000 |
+---------------------------------------------------------------------------------+
The information output is very detailed and provides a summary of all the configuration and status information for the given host. The connector
information shows connectors made to each configured dataserver by each connector service. The datasource section shows detailed information on
the dataserver and replicator services. The output from the replicator service is equivalent to that output by trepctl .