Changelog category (leave one):

• New Feature

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

Add support for dynamic replica reconnection in the Cluster class, enabling automatic reconnection to available replicas if some replicas become unavailable during query execution.

Documentation entry for user-facing changes

• Documentation is written (mandatory for new features)

Documentation Information:

• Motivation: Ensures that queries can continue execution by reconnecting to other available replicas if some replicas become unavailable, improving the resilience of the cluster.
• Parameters:
  • Cluster::reconnectToReplica: Method to attempt reconnection to a replica if it is not connected.
  • Cluster::handleDynamicReplicas: Method to handle the dynamic reconnection logic for replicas.

Information about CI checks: https://clickhouse.com/docs/en/development/continuous-integration/

CI Settings (Only check the boxes if you know what you are doing):

• Allow: All Required Checks
• Allow: Stateless tests
• Allow: Stateful tests
• Allow: Integration Tests
• Allow: Performance tests
• Allow: All Builds
• Allow: batch 1, 2 for multi-batch jobs
• Allow: batch 3, 4, 5, 6 for multi-batch jobs

• Exclude: Style check
• Exclude: Fast test
• Exclude: All with ASAN
• Exclude: All with TSAN, MSAN, UBSAN, Coverage
• Exclude: All with aarch64, release, debug

• Do not test
• Woolen Wolfdog
• Upload binaries for special builds
• Disable merge-commit
• Disable CI cache

This addresses issue #58380.
and is rebased from #66791