Monitor Replication Query
Joseph
Vertica Customer
We're replicating some schemas to another (standby) cluster.
I'm really just wanting to monitor what is actually being replicated.
So basically it's nice to be able to see what is actually being replicated within the schemas maybe with knowing the last replicated epoch there should be a query to be able to work out what has changed since that epoch..... which should then give the result ..... I suppose the nicer thing about the query is that it would be predictive ....
If you have some insight into a query that would be good.
Tagged:
-1
Answers
How about using this system table?
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/MONITOR/REMOTE_REPLICATION_STATUS.htm
Thanks I'd previously found REMOTE_REPLICATION_STATUS..... this give the replicated_epoch and the current_epoch for example here is are the results
replicated_time
replicated_epoch
current_epoch
---------------------------------------------------------------------------------------------------------------------------+-----------------+--------------------------------------------------+------------------------+------------------+---------------
DBACORE,BI_WORKSPACE,BI_PROD,AUDIT,HPI,HOMEGATE,SEANO,WARWICK,AVM_STATS_LIVE1,AVM_STATS_LIVE2,AVM_STATS_SANDBOX1,DS_STATS
backup_snapshot
backup_snapshot_G77VS3ZMEX613XL3RHILAPHQRR2GL4TT
2020-07-28 13:27:47+01
1433059
1434707
(1 row)
but looking at the output from vbr command I see ......
Snapshotting the source database.
Snapshot complete.
Copying catalog snapshot from source to destination.
Preparing destination database for replicating objects.
Prep complete, start syncing files.
Approximate bytes to copy: 267765680544 of 1538277261507 total.
[====..............................................] 9%
so what I'd like to know (or even be able to look at in advance) is what is making up the 267765680544 bytes that it mentions - this equates to approx 250GB
the vbr log itself - this doesn't seem very informative ..... but whilst vbr is running there is a directory with _to_copy.manifest when this then contains the sal_storage_id ...... so using this I can sort of work out what is being copied .... but is there no way that I can work this out using the epochs and a straightforward query maybe ?