2 ms·
As someone who has never had to perform this kind of recovery: why is it so hard?
by ollien 5y ago
As someone who has never had to perform this kind of recovery: why is it so hard?
- jacquesm 5y agoBecause it is very difficult to maintain relational integrity during a restore like that.
- ollien 5y agoGotcha. I guess you could be heavy-handed and disable foreign key checks, but who knows what other bugs that would bring into the mix.
- teling2 5y agoThe other difficulty is if you don't restore the entire state in a single transaction. Imagine you have partial data restored in Table A but haven't updated Table B correspondingly. Now some other program that consumes Table A and Table B and doesn't have error handling will crash (or worse, mutate state in other weird ways).
- jacquesm 5y agoThat is relational integrity.