v.24.1New Feature

Added null_status_on_timeout_only_active and throw_only_active modes for distributed_ddl_output_mode

Added null_status_on_timeout_only_active and throw_only_active modes for distributed_ddl_output_mode that allow to avoid waiting for inactive replicas. #58350 (Alexander Tokmakov).
Added new modes null_status_on_timeout_only_active and throw_only_active for the distributed_ddl_output_mode setting, enabling DDL queries to skip waiting on inactive replicas.

Why it matters

This feature addresses the issue of delays during distributed DDL operations caused by waiting for inactive replicas. By allowing the system to ignore inactive replicas, it improves query responsiveness and reliability when some replicas are down or unreachable.

How to use it

Set the distributed_ddl_output_mode parameter to either null_status_on_timeout_only_active or throw_only_active to enable skipping inactive replicas during distributed DDL execution.