4 sysbench测试tidb多节点高可用集群 numa 32张表每张表1000W

最新推荐文章于 2025-11-21 15:49:44 发布

原创

最新推荐文章于 2025-11-21 15:49:44 发布 · 349 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #TiDB

该文档详细描述了如何配置和优化一个TiDB分布式数据库集群，包括物理机配置、IP设置、系统参数调整、免密登录配置、集群拓扑定义以及性能测试的过程。通过这些步骤，确保了集群的稳定性和高效运行。

实例	个数	物理机配置	IP	配置
TiDB	3	16 VCore 32GB * 1	192.168.100.110 192.168.100.112 192.168.100.113	默认端口全局目录配置
PD	3	4 VCore 8GB * 1	192.168.100.110 192.168.100.112 192.168.100.113	默认端口全局目录配置
TiKV	3	16 VCore 32GB 2TB (nvme ssd) * 1	192.168.100.110 192.168.100.112 192.168.100.113	默认端口全局目录配置
Monitoring & Grafana	1	4 VCore 8GB * 1 500GB (ssd)	192.168.100.110	默认端口全局目录配置

一、环境与系统配置检查开始

fdisk /dev/nvme0n1

parted -s -a optimal /dev/nvme0n1 mklabel gpt -- mkpart primary ext4 1 -1

mkfs.ext4 /dev/nvme0n1p1

lsblk -f 记录下UUID

vim /etc/fstab

UUID=xxxxx /nvme0 ext4 defaults,nodelalloc,noatime 0 2

mkdir /nvme0 && \ mount -a

mount -t ext4

fdisk /dev/nvme1n1

d w

parted -s -a optimal /dev/nvme1n1 mklabel gpt -- mkpart primary ext4 1 -1

mkfs.ext4 /dev/nvme1n1p1

lsblk -f 记录下UUID

vim /etc/fstab

UUID=xxxxx /nvme1 ext4 defaults,nodelalloc,noatime 0 2

mkdir /nvme1 && mount -a

mount -t ext4

echo "vm.swappiness = 0">> /etc/sysctl.conf swapoff -a && swapon -a sysctl -p

firewall-cmd --state

sudo systemctl stop ntpd.service && \ sudo ntpdate 192.168.100.220 && \ sudo systemctl start ntpd.service

cat /sys/kernel/mm/transparent_hugepage/enabled

cat /sys/block/sd[bc]/queue/scheduler

udevadm info --name=/dev/sdb | grep ID_SERIAL

记录下ID_SERIAL

cpupower frequency-info --policy

tuned-adm list

mkdir /etc/tuned/balanced-tidb-optimal/ vim /etc/tuned/balanced-tidb-optimal/tuned.conf

[main]
include=balanced

[cpu]
governor=performance

[vm]
transparent_hugepages=never

[disk]
devices_udev_regex=(ID_SERIAL=xxx)|(ID_SERIAL=xxxx)
elevator=noop

tuned-adm profile balanced-tidb-optimal

cat /sys/kernel/mm/transparent_hugepage/enabled

cat /sys/block/sd[bc]/queue/scheduler

cpupower frequency-info --policy

echo "fs.file-max = 1000000">> /etc/sysctl.conf echo "net.core.somaxconn = 32768">> /etc/sysctl.conf echo "net.ipv4.tcp_tw_recycle = 0">> /etc/sysctl.conf echo "net.ipv4.tcp_syncookies = 0">> /etc/sysctl.conf echo "vm.overcommit_memory = 1">> /etc/sysctl.conf echo "vm.swappiness = 0">> /etc/sysctl.conf sysctl -p

cat >/etc/security/limits.conf tidb soft nofile 1000000 tidb hard nofile 1000000 tidb soft stack 32768 tidb hard stack 32768 EOF

useradd tidb && \ passwd tidb

visudo