3 sysbench测试tidb多节点高可用集群

 

实例	个数	物理机配置	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 | gr