Skip to main content
Common Reference

thl dsctl

Version availability

Available in 7.0.2 and later.

The thl dsctl 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

Usage
thl dsctl [common-options] [arguments]

Where:

OptionDescriptionVersion
-eventOutputs dsctl command for a given event.
-firstOutputs dsctl command for the first THL entry available.7.1.4
-lastOutputs dsctl command for the last THL entry available.7.1.4
-seqnoOutputs dsctl command for a given sequence number.
  • 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"
  • 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"
  • Outputs a dsctl command for either the first or last seqno available:

    Version availability

    Available in 7.1.4 and later.

    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"