tidb怎么使用MySQL_TiDB安装与使用-安装

1、推荐以下配置

角色配置磁盘数量IP说明

TiDB8C64GHDD 500G2172.28.1.11

172.28.1.12

PD4C8GHDD 200G3172.28.1.21

172.28.1.22

172.28.1.23

TiKV8C64GSSD 2T3172.28.1.31

172.28.1.32

172.28.1.33

Pump8C16GHDD 300G3172.28.1.41

172.28.1.42

172.28.1.43binlog

Drainer8C16GHDD 300G1172.28.1.44binlog

Monitoring & Grafana4C8GHDD 500G1172.28.1.51

mysql8C64GHDD 2T2172.28.1.61

172.28.1.62备份用，主从架构

2、TiDB共13台服务器，使用Monitoring服务器172.28.1.51作为中控机服务器，在每台服务器上创建用户tidb，并设置密码(passwd tidb)、免密提权(echo "tidb ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers)

3、安装配置mysql主从

4、设置服务器互信(中控机172.28.1.51操作)

ssh-keygen -t rsa

ssh-copy-id -i ~/.ssh/id_rsa.pub TiDB各服务器IP

5、tiup安装

sudo su - tidb

curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

source .bash_profile

tiup cluster

6、配置文件topology.yaml

# # Global variables are applied to all deployments and used as the default value of

# # the deployments if a specific deployment value is missing.

global:

user: "tidb"

ssh_port: 22

deploy_dir: "/data/tidb-deploy"

data_dir: "/data/tidb-data"

server_configs:

pd:

replication.enable-placement-rules: true

tidb:

binlog.enable: true

binlog.ignore-error: true

pd_servers:

- host: 172.28.1.21

- host: 172.28.1.22

- host: 172.28.1.23

tidb_servers:

- host: 172.28.1.12

- host: 172.28.1.13

tikv_servers:

- host: 172.28.1.31

- host: 172.28.1.32

- host: 172.28.1.33

pump_servers:

- host: 172.28.1.41

data_dir: /data/tidb-data/drainer-8250

deploy_dir: /data/tidb-deploy/drainer-8250

config:

gc: 7

- host: 172.28.1.42

data_dir: /data/tidb-data/drainer-8250

deploy_dir: /data/tidb-deploy/drainer-8250

config:

gc: 7

- host: 172.28.1.43

data_dir: /data/tidb-data/drainer-8250

deploy_dir: /data/tidb-deploy/drainer-8250

config:

gc: 7

drainer_servers:

- host: 172.28.1.44

port: 8249

data_dir: /data/tidb-data/drainer-8249

deploy_dir: /data/tidb-deploy/drainer-8249

commit_ts: -1

config:

syncer.db-type: "mysql"

syncer.to.host: "172.28.1.61"

syncer.to.user: "root"

syncer.to.password: "密码"

syncer.to.port: 3306

monitoring_servers:

- host: 172.28.1.51

grafana_servers:

- host: 172.28.1.51

alertmanager_servers:

- host: 172.28.1.51

7、执行集群部署

tiup cluster deploy 集群名称 v4.0.8 ./topology.yaml

8、查看集群状态(此时为down状态)

tiup cluster desplay 集群名称

9、启动集群

tiup cluster 集群名称 start