9.23.2. thl dsctl Command

The dsctl command to the thl command outputs a dsctl command that can be executed against a replicator to assist in repositioning.

The command is displayed only, it is not executed

thl dsctl
[-seqno # ]
[-event # ] [-first] [-last]

  • -event eventid

    Output a dsctl command for the given eventid, for example:

    shell> thl dsctl -event mysql-bin.000017:0000000074628349 
    dsctl -service alpha set -reset -seqno 916 -epoch 538 -event-id "mysql-bin.000017:0000000074628349;62" -source-id "centos1"
  • -seqno #

    Output a dsctl command for the given sequence number, for example:

    shell> thl dsctl -seqno 916 
    dsctl -service alpha set -reset -seqno 916 -epoch 538 -event-id "mysql-bin.000017:0000000074628349;62" -source-id "centos1"
  • -first | -last

    This option was added in version 7.1.4.

    Outputs a dsctl command for either the first or last seqno available:

    shell> thl dsctl -first 
    dsctl -service alpha set -reset -seqno 1 -epoch 538 -event-id "mysql-bin.000001:0000000000008349;62" -source-id "centos1"
    shell> thl dsctl -last 
    dsctl -service alpha set -reset -seqno 237 -epoch 538 -event-id "mysql-bin.000001:0000000002791835;41" -source-id "centos1"