3 ms·
> In what situations would a delayed replica be useful? When we start to have slightly larger databases (multi terabyte) then delayed replicas become a very us
by dc2447 13y ago
> In what situations would a delayed replica be useful?
When we start to have slightly larger databases (multi terabyte) then delayed replicas become a very useful backup and recovery strategy. Typically we need to recover databases when there has either been human error (someone deletes a bunch of data they should not have) or a compromise. In these situations rather than restoring for a nightly backup it is _always_ faster to roll a delayed replica forward and promote it to be master then resync all the normal replicas.