system.clusters

    Columns:

    • (String) — The cluster name.
    • shard_num (UInt32) — The shard number in the cluster, starting from 1.
    • shard_weight (UInt32) — The relative weight of the shard when writing data.
    • replica_num (UInt32) — The replica number in the shard, starting from 1.
    • host_name (String) — The host name, as specified in the config.
    • host_address (String) — The host IP address obtained from DNS.
    • port (UInt16) — The port to use for connecting to the server.
    • user (String) — The name of the user for connecting to the server.
    • errors_count (UInt32) - number of times this host failed to reach replica.
    • estimated_recovery_time (UInt32) - seconds left until replica error count is zeroed and it is considered to be back to normal.

    See also

    2. cluster:                 test_cluster
    3. shard_num:               1
    4. shard_weight:            1
    5. replica_num:             1
    6. host_name:               clickhouse01
    7. host_address:            172.23.0.11
    8. port:                    9000
    9. is_local:                1
    10. user:                    default
    11. default_database:        
    12. errors_count:            0
    13. estimated_recovery_time: 0
    16. cluster:                 test_cluster
    17. shard_num:               1
    18. shard_weight:            1
    19. replica_num:             2
    20. host_name:               clickhouse02
    21. host_address:            172.23.0.12
    22. port:                    9000
    23. is_local:                0
    24. user:                    default
    25. default_database:        
    26. errors_count:            0
    27. estimated_recovery_time: 0