sql: provide failure scenario recommendations for multi-region databases

[awoods187]

Andy Woods (awoods187) commented:

@a-entin shared with us that "Robust operations in a MR requires a fairly involved/elaborate failover and failback. For example, global tables must be “re-homed”. There are other steps an application needs to implement for a meaningful region failure handling."

We should provide guidance on failover scenarios for multi-region databases. This includes the intersection of different survival goals and tables types, under different failover scenarios (e.g., primary region, other region).

Jira Issue: DOC-722

[exalate-issue-sync[bot]]

Vy Ton (vy-ton) commented: Andy Woods Can you confirm the priority of this issue?

[exalate-issue-sync[bot]]

Andy Woods (awoods187) commented: I think this should be high to communicate some limitations when using the new abstractions.