[TiDBer Chat Session 86] Master-Level Strategies for TiDB Load Balancing: Can Anyone Teach Me?

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

Original topic: 【TiDBer 唠嗑茶话会 86】TiDB 负载均衡的大师级策略:有谁能教教我?

| username: TiDB社区小助手

Load balancing is a common issue that many friends encounter with TiDB. Recently, some TiDBers in the community have been troubled by this problem :thinking: Fortunately, we have load balancing masters in our community :eyes: As they say, “When the masters arrive, load balancing becomes invincible!”

In this chat session, let’s talk about your load balancing experiences and solutions! What TiDB load balancing solutions are you all using? :eyes: :raised_hands:

This Topic:

What load balancing solutions do you generally use for TiDB? Any good suggestions?

Event Rewards:

Participation Award

Participate in this chat session discussion to receive 30 points as a reward.

Event Duration:

2023.9.15-2023.9.21

Recommended Reading:

| username: Kongdom | Original post link

HAProxy + keepalived

| username: 像风一样的男子 | Original post link

Alibaba Cloud SLB

| username: 大飞哥online | Original post link

Proxy + keepalived

F5

| username: zhanggame1 | Original post link

Currently testing with HAproxy, no issues following the official best practices.
Will use F5 for the official launch.

| username: TiDBer_Wp | Original post link

Passing by without load balancing experience, here to learn.

| username: Jellybean | Original post link

Ngoni/HAProxy + keepalived

| username: xfworld | Original post link

  1. Round-robin load balancing

  2. Weighted load balancing

  3. Consistent hashing

  4. Response time

  5. Least connections


Generally, round-robin load balancing is used. Just use it without thinking… No burden…

| username: 半瓶醋仙 | Original post link

Use a proxy and set cost priority to control traffic.

| username: 昵称想不起来了 | Original post link

HAProxy + keepalived

| username: TiDBer_zujGKwCY | Original post link

HAProxy + keepalived

| username: Aionn | Original post link

HAProxy + keepalived

| username: TiDB_C罗 | Original post link

Cloud vendor’s load balancer

| username: YuchongXU | Original post link

Nginx

| username: TiDBer_m6V1BalM | Original post link

Hardware load balancing LSB or software type load balancing LVS/HA

| username: ealam_小羽 | Original post link

HAProxy + keepalived

| username: TiDBer_vfJBUcxl | Original post link

HAProxy + keepalived

| username: Fly-bird | Original post link

Using Alibaba Cloud’s SLB for direct load balancing.