start with multi-ip addresses --advertise-address=192.168.7.210 xxx.xxx.18.210 couldn't connect server success

[heming79]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Tidb 4.0.7 vim /etc/hosts
192.168.7.210 yz-mbg-018210
xxx.xxx.18.210 yz-mbg-018210
hostname -i 输出 192.168.7.210 xxx.xxx.18.210
启动tidb 会导致启动参数 --advertise-address=192.168.7.210 xxx.xxx.18.210
此时4000端口监听正常 ，但是 mysql连接报授权失败

2. What did you expect to see? (Required)

希望做一下参数判断 如果 --advertise-address 超过一个值就报异常 ，不要启动端口监听 ，避免前端lvs或者 haproxy 认为后端可用不利于高可用 ，不利于查问题

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

4.0.7

[heming79]

或者检查一下 为什么这种情况tidb服务不可用

[lysu]

Thanks for your feedback.

Yes, -advertise-address should add check, but it seems there are some misunderstand for you about advertise-address usage.

First, for go's flag.String, you can not split multiple parameters with SPACE(" "), so for your command tidb only recieve 192.168.7.210, you need surround it with quota like this --advertise-address="192.168.7.210 xxx.xxx.18.210", but sadly it didn't do only-one-host validation
Second, -advertise-address is a advertise address to others, real bind host is -host(why need two configuration, #7078 (comment) has some explain), but we also cannot bind multi host now

Currently, TiDB only support bind one address via -host, and using -advertise-address to advertise host to others(e.g. bind 0.0.0.0 but export real api to other service)

if you configuration multiple host in -host(e.g. -host='addr1 addr2' it will report error before startup), maybe we need add checks for advertise-address, do you interesting to write a PR to do this simple check :D

[TszKitLo40]

I have filed a PR, PTAL @lysu