Checking Monitoring Metrics of ClickHouse Replication Table Data Synchronization

No data: The table has no data on this shard.
Synchronized: The table has data on this shard, and multiple instance copies of the same shard are the same.
Not synchronized: The table has data on this shard, but multiple instance copies of the same shard are not the same.

MRS monitors the synchronization between multiple replicas of data in the same shard of a Replicated*MergeTree table.

Currently, you can monitor and query only Replicated*MergeTree tables whose creation statements contain the key word ON CLUSTER.

Procedure
Log in to FusionInsight Manager of a cluster earlier than MRS 3.2.0, click Cluster, choose Services > ClickHouse, and click Data Synchronization Status.

Log in to FusionInsight Manager of an MRS 3.2.0 cluster or later, click Cluster, choose Services > ClickHouse, click Logic Cluster, and click the name of the target logical cluster. Go to the logical cluster page and select Data Synchronization Status.

Data synchronization parameters

**Table 1** Data synchronization parameters
Parameter	Description
Data Tables	Names of Replicated*MergeTree tables.
Database	Database where the data table is located.
Shard	ClickHouse shard where the data table is located.
Status	Data synchronization status. The options are as follows: No data: The table has no data on this shard. Synchronized: The table has data on this shard, and multiple instance copies of the same shard are the same. Not synchronized: The table has data on this shard, but multiple instance copies of the same shard are not the same.
Details	Data synchronization details of the data table on the corresponding ClickHouseServer instance.