dsctl set
The dsctl set command sets the current replicator position.
Usage
dsctl [common-options ] set [ options ]
Where:
| Option | Description | Version |
|---|---|---|
-epoch | Epoch Number. | |
-event-id | Source Event ID. | |
-reset | Resets the datasources before performing set operation. | |
-seqno | Sequence number. | |
-source | Source ID. |
important
When using this option, the -seqno,-epoch,-event-id and -source-id options must be specified to
set the corresponding values in the replicator.
If a configuration exists, and you do not specify the -reset then an error will be displayed, for example:
shell> dsctl set -seqno 214 -epoch 0 -event-id "mysql-bin.000011:0000000000072857;8196" -source-id "db1"
Cannot set position unless existing position data is removed - reset first
Either issue the reset as a separate option, or include in the single command, for example:
shell> dsctl reset
Service "alpha" datasource "global" catalog information cleared
shell> dsctl set -seqno 214 -epoch 0 -event-id "mysql-bin.000011:0000000000072857;8196" -source-id "db1"
Service "alpha" datasource "global" position was set to: seqno=214 epoch_number=0 eventid=mysql-bin.000011:0000000000072857;8196 source_id=db1
Or:
shell> dsctl set -seqno 214 -epoch 0 -event-id "mysql-bin.000011:0000000000072857;8196" -source-id "db1" -reset
Service "alpha" datasource "global" catalog information cleared
Service "alpha" datasource "global" position was set to: seqno=214 epoch_number=0 eventid=mysql-bin.000011:0000000000072857;8196 source_id=db1