cli: cockroach mt start-sql does not support the --locality-advertise-addr argument

[knz]

Describe the problem

For KV node-node connections, we support a --locality-advertise-addr that tells nodes to use different hostnames to connect to other nodes depending on their locality. This enables customizing which addresses are exposed in k8s in each region.

For multi-region serverless support, we'll need a similar mechanism for communication between SQL-only servers.

However, currently the --locality-advertise-addr flag is not supported by SQL-only servers. It probably should.

Might relate to #52266
Might relate to #42741

Jira issue: CRDB-20621

[knz]

cc @jeffswenson for consideration

[jeffswenson]

The --locality-advertise-addr is not needed by Multi Region Serverless. We set up the VPC so that each region has a unique ip range and regions are able to route to each other via the internal ip address.

[github-actions]

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!