v.22.9New Feature

Support auto-insert quorum for majority number

Support insert_quorum = 'auto' to use majority number. #39970 (Sachin).
Support for insert_quorum = 'auto' mode to automatically use the majority of replicas for quorum inserts.

Why it matters

This feature allows users to set the insert_quorum setting to 'auto', which automatically calculates and uses the majority number of replicas in a replicated table for quorum inserts. It simplifies the configuration and improves reliability without requiring manual quorum size specification.

How to use it

To enable this feature, set the insert_quorum setting to 'auto' in your INSERT query or in your session settings, for example:

SET insert_quorum = 'auto';
INSERT INTO replicated_table VALUES (...);