Checking Monitoring Metrics of ClickHouse Replication Table Data Synchronization

Updated on 2024-12-13 GMT+08:00

View PDF

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.

Filter conditions
You can select By Data Tables and enter a data table name in the search box to filter data tables.

Parent topic: Enterprise-Class Enhancements of ClickHouse

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.