sql/kv: enhance multi-region migration docs with replica placement

[awoods187]

Andy Woods (awoods187) commented:

In https://github.com/cockroachdb/docs/pull/11057, we plan to write a migration from the old primitive patterns to the new multi-region abstractions (this will also allow us to link to the old patterns for discoverability for existing users of the old patterns without making them front and center for new users). We are creating this guide to assure customers that they don't need to migrate immediately and to help them understand how the new patterns translate and build upon the existing primitives. In the new primitives, we aspire for our users to not need to understand leaseholder and replica placement. However, until we fully realize this goal (which also includes addressing data domiciling) we still need to communicate, especially for users of the primitives, how replicas are placed using the new patterns. We can augment this existing doc with this information to help our current users without overcrowding the main docs pages for new users. As an initial proposal, it was suggested that we add a table for voting/non-voting replica for each table type as well as a reference to check replica placement by using the replication reports.

Jira Issue: DOC-1420

[exalate-issue-sync[bot]]

Vy Ton (vy-ton) commented: Andy Woods Adam Storm What are your thoughts on the priority of this issue?

[exalate-issue-sync[bot]]

Andy Woods (awoods187) commented: I’d say medium--its reference detail that is fairly straightforward and needs to be available in some form or fashion. We def don't want to put it front and center but it should be available.

[exalate-issue-sync[bot]]

Richard Loveland (rmloveland) commented: Not exactly this but related: https://cockroachlabs.atlassian.net/wiki/x/XIFijw

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 18 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to CockroachDB docs!