Shows the list of all connections between the replication master and secondary databases.

SHOW REPLICATION STATUS

Notes

• The URI identifies the database as <host>:<port>/<dbName>.
• Log position is the position in the transactional log formatted as <LogFileId>:<ByteOffsetInLogFile>.
• Each database in replicating mode has two background threads (SecondaryNetwork and SecondaryReplay). The state and position of both threadss are displayed per-database. The SecondaryNetwork thread downloads the necessary snapshot files and transaction logs from the primary database and the SecondaryReplay thread reads transactions from these files and commits them to memory.
• The difference between MasterLogPos and SecondaryReplayPos is the current replication lag. When the replica synchronizes fully with the master, all three log positions are identical.
• This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).

Output

Example

memsql> SHOW REPLICATION STATUS;
+-------------+-----------------------------+--------------+-------------------------------+-----------+-----------------+------------------+----------------+
| Role        | MasterURI                   | MasterLogPos | SlaveURI                      | Connected | SecondaryNetworkPos | SecondaryReplayState | SecondaryReplayPos |
+-------------+-----------------------------+--------------+-------------------------------+-----------+-----------------+------------------+----------------+
| async slave | users-instance-A:3306/users | 0:8870       | localhost:3306/users          | yes       | 0:8870          | replicating      | 0:8870         |
+-------------+-----------------------------+--------------+-------------------------------+-----------+-----------------+------------------+----------------+

Was this Article Helpful?

Thanks For Your Feedback!