From version 7.2.0, the MySQL 8.4 syntax of show replica 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 show replica status 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)
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>';