v.21.9Improvement

Added replica_is_active column to system.replicas table

Added columns replica_is_active that maps replica name to is replica active status to table system.replicas. Closes #27138. #27180 (Maksim Kita).
Added a new column replica_is_active to the system.replicas table that indicates the active status of each replica.

Why it matters

This feature provides users with immediate visibility into whether a replica is currently active, simplifying monitoring and diagnostics for replicated tables.

How to use it

Query the system.replicas table and include the replica_is_active column to check the active status of replicas, for example:
SELECT replica_name, replica_is_active FROM system.replicas