TIDB学习笔记

tidb用户密码：tidb asd123ASD

ssh 密钥

SHA256:YSA6u5H8Zn5qTL2XmIzivKeoTw0AAYWnQPfxBQBxx4s tidb@tidb-ansible-101
The key's randomart image is:
+---[RSA 2048]----+
|*=.++++o..       |
|+ o.o.+o.        |
|ooo  ...+        |
|.o + E o .       |
|  *  .  S        |
|   *. .          |
|  oo=o + .       |
| +.+= * o        |
|+o**oo .         |
+----[SHA256]-----+

部署注意

1.机器的计算机名不能相同

2.初始化参数时报错

This machine does not have sufficient CPU to run TiDB, at least 8 cores

类似相关硬件限制问题可修改roles/check_system_optional/defaults/main.yml文件里的参数来解决如上面问题可以修改tidb_min_cpu参数

注意，修改参数时不能在行尾部留空格，不然报错

3.报

fatal: [192.168.56.223]: FAILED! => {"changed": false, "failed_when_result": true, "rc": 0, "stderr": "Shared connection to 192.168.56.223 closed.\r\n", "stderr_lines": ["Shared connection to 192.168.56.223 closed."], "stdout": "/dev/mapper/centos-root  8.0G  8.0G  280K  100% /\r\n", "stdout_lines": ["/dev/mapper/centos-root  8.0G  8.0G  280K  100% /"]}

错误tikv虚拟机根目录分区太小，需要扩容

https://www.codetd.com/article/2284025 虚拟机安装可参考此篇

https://blog.csdn.net/sunny05296/article/details/65980897/ npt时间同步配置可参考此篇

执行：ansible-playbook bootstrap.yml 如果报

fio randread iops of deploy_dir disk is too low

原因是：硬盘太慢，tidb对硬盘的IOPS有一定的要求，要大于40000，生产环境官方建议使用 NVMe SSD 硬盘

使用dev模式

参考https://github.com/pingcap/tidb-ansible/issues/521

ansible-playbook bootstrap.yml --extra-vars "dev_mode=True"

Grafana Web 默认账号: admin 密码: admin

参考此篇安装https://www.codetd.com/article/2284025

注意：主机名一定不能冲突，hostnamectl set-hostname tidb-server-191 常见错误：http://1bb.work/jxadd/article_detail/3426