v.23.1Improvement
Added Settings to Disallow Concurrent Backups and Restores in ClickHouse
Added settings to disallow concurrent backups and restores resolves #43891 Implementation: * Added server-level settings to disallow concurrent backups and restores, which are read and set when BackupWorker is created in Context. * Settings are set to true by default. * Before starting backup or restores, added a check to see if any other backups/restores are running. For internal requests, it checks if it is from the self node using backup_uuid. #45072 (SmitaRKulkarni).
Why it matters
This feature addresses the issue of concurrent backup and restore operations running simultaneously on the server, which can cause conflicts or data inconsistencies. By disallowing concurrent backups and restores, it ensures safer and more reliable data management during these critical operations.How to use it
The settings to disallow concurrent backups and restores are enabled by default on the server. Users do not need to take any action to enable them. Before starting a backup or restore, ClickHouse checks if any other backup or restore is currently running and prevents concurrent execution. For internal requests, it verifies the operation origin usingbackup_uuid to allow safe identification of self node operations.