Help Center> MapReduce Service> Component Operation Guide (LTS)> Using ClickHouse> Monitoring of Slow ClickHouse Query Statements and Replication Table Data Synchronization> Replication Table Data Synchronization Monitoring
Updated on 2023-04-28 GMT+08:00
View PDF

Replication Table Data Synchronization Monitoring

Scenario

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

Constraints

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

Replication Table Data Synchronization

  • Procedure

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

    Log in to FusionInsight Manager of MRS 3.2.0 or later, click Cluster, choose Services > ClickHouse, and click the name of the target logical cluster. On the displayed page, click 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.