Richard S. wrote:very brief period in the AM of few minutes when it is inaccessible because the database tables are locked for a backup
Only sissies do backups.
When I first started working with computers, when dinosaurs still trod the earth, we had no disks. Then came disks but they were so unreliable that, before doing software upgrades, I would take AT LEAST two separate backups to tape, then more double-backups in the course of the upgrade, because of course tapes were pretty unreliable too. Then disks improved, then tapes gradually caught up in reliability, then with RAID protection combined with hot spares disk failures became so rare they are hardly a consideration. The main reason for backups now is to protect against software and human errors that lose or scramble the data.
But I'm still a wicked sissy.