Connector show slave status Command

Behavior Change

Behavior Change since 7.2.0.

From version 7.2.0, the MySQL 8.4 syntax of show slave status can be used and will be recognized. The old syntax can also still be used and the connector will automatically convert as needed to match the underlying MySQL environment.

The command generates a version of the standard MySQL command, with the output replaced with values generated by Tungsten. This can be useful for environments where the replica status need to be checked, but with the Tungsten Replicator state, rather than native replication.

mysql> show slave status;
*************************** 1. row ***************************
           Slave_IO_State:
              Master_Host: host1
              Master_User:
              Master_Port: 0
            Connect_Retry: 0
...
...

1 row in set (0.01 sec)

mysql> show replica status;
*************************** 1. row ***************************
         Replica_IO_State:
              Source_Host: host1
              Source_User:
              Source_Port: 0
            Connect_Retry: 0
...
...

1 row in set (0.01 sec)

note

If the connector is configured in Proxy mode, then any user executing this statement will require the SELECT privilege on the tracking schema table trep_commit_seqno. The following DDL can be used as an example:

GRANT SELECT ON tungsten_[servicename].trep_commit_seqno TO '[user]'@'[host]';