Failed to Pass Through Configuration in Three-Node Mixed Deployment of TiDB

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 三节点混合部署TiDB配置透传失败

| username: TiDBer_4XCw6F4E

[TiDB Usage Environment] Testing
[TiDB Version] v8.1.0
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Problem Description and Impact]
I currently have only 3 virtual machines, with each node deploying TiDB server + TiKV + PD.
Additionally, I want to achieve load balancing and high availability, so I installed HAProxy + Keepalived on each node. I have added the send-proxy parameter in the HAProxy configuration file and also added the proxy-protocol.networks parameter in the TiDB configuration. However, there are still issues with transparency, as executing show processlist; still shows the virtual IP.

Dear experts, how can I achieve transparency and load balancing with this three-node deployment architecture?

[Resource Configuration]

image
image885×833 28.5 KB

[Attachments: Screenshots/Logs/Monitoring]

image
image1119×140 5.05 KB

2
| username: Kongdom | Original post link

Are you referring to this configuration? When there are three nodes, all three nodes need to be configured.

3
| username: TiDBer_4XCw6F4E | Original post link

All three nodes are configured, but it’s still useless. :joy:

4
| username: tidb菜鸟一只 | Original post link

Please send the configuration files for TiDB and HAProxy.

5
| username: Kongdom | Original post link

Did you reload after configuring? It will only take effect after reloading.

6
| username: TiDBer_7S8XqKfl | Original post link

Indeed, you need to check the configuration parameters or see if there are any error logs.

7
| username: db_user | Original post link

It seems there might be an issue with the configuration. If you have indeed configured passthrough, with three mixed deployments, and both HAProxy and TiDB are on the same node, then you won’t be able to open the dashboard. Please share the specific configuration file.

8
| username: TIDB-Learner | Original post link

Everyone says it’s a configuration file issue. It feels like either it’s configured incorrectly or it hasn’t taken effect.

9
| username: TiDBer_3Cusx9uk | Original post link

You need to check the configuration file.

10
| username: zhanggame1 | Original post link

Directly copy the official documentation configuration, I have tested it without any issues.
HAProxy Best Practices in TiDB | PingCAP Documentation Center

11
| username: TiDBer_7S8XqKfl-1158 | Original post link

It feels like the configuration file didn’t take effect.