数据库版本
集群整体架构
IP地址 | 系统版本 | 备注 |
---|
192.168.222.150 | centos7.9 | 原tidb7.6集群 |
192.168.222.151 | centos7.9 | 原tidb7.6集群 |
192.168.222.152 | centos7.9 | 原tidb7.6集群 |
192.168.222.153 | centos8.3 | 扩容资源,升级到tidb8.5以后的主集群 |
192.168.222.154 | centos8.3 | 扩容资源,升级到tidb8.5以后的主集群 |
192.168.222.155 | centos8.3 | 扩容资源,升级到tidb8.5以后的主集群 |
设置 SSH 免密登录
- 192.168.222.150 主机上执行集群部署,扩容,缩容等
设置密钥
ssh-keygen -t rsa -b 4096
分发公钥到所有目标节点
for i in {0..5};do echo $i;ssh-copy-id root@192.168.222.15$i ;done
tidb 安装
安装 TiUP:
curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh
设置环境变量:
source /root/.bash_profile
更新 TiUP:
tiup update --self
tiup update cluster
部署 TiDB 集群
tiup cluster template > topology.yaml
[root@localhost tidb]
global:
user: "tidb"
ssh_port: 22
deploy_dir: "/data/tidb/tidbdeploy"
data_dir: "/data/tidb//tidbdata"
pd_servers:
- host: 192.168.222.152
tidb_servers:
- host: 192.168.222.150
tikv_servers:
- host: 192.168.222.150
- host: 192.168.222.151
- host: 192.168.222.152
monitoring_servers:
- host: 192.168.222.151
grafana_servers:
- host: 192.168.222.151
部署集群:
[root@localhost tidb]
tiup cluster deploy tidb-cluster v7.6.0 tidb-cluster.yaml -u root
启动集群:
tiup cluster start tidb-cluster --init
查看集群状态:
tiup cluster display tidb-cluster
更改root密码
/home/data/mysql-8.0.30-el7-x86_64/bin/mysql -h 192.168.222.150 -P 4000 -u root -p'D-*^Jaz4@u13X59Z2b'
ALTER USER 'root'@'%' IDENTIFIED BY '123456';
部署了什么集群
tiup cluster list
集群进行扩容
PD 扩容
[root@iZt4necvvu7hu3t950mf3cZ tidb]
global:
user: "root"
ssh_port: 22
deploy_dir: "/data/tidb/tidbdeploy"
data_dir: "/data/tidb/tidbdata"
arch: "amd64"
os: "linux"
pd_servers:
- host: 192.168.222.155
ssh_port: 22
name: pd
client_port: 2379
peer_port: 2380
deploy_dir: /data/tidb/tidbdeploy/pd-2379
data_dir: /data/tidb/tidbdata/pd-2379
log_dir: /data/tidb/tidbdeploy/pd-2379/log
tidb server 扩容
[root@iZt4necvvu7hu3t950mf3cZ tidb]
global:
user: "root"
ssh_port: 22
deploy_dir: "/data/tidb/tidbdeploy"
data_dir: "/data/tidb/tidbdata"
arch: "amd64"
os: "linux"
tidb_servers:
- host: 192.168.222.153
ssh_port: 22
port: 4000
status_port: 10080
deploy_dir: /data/tidb/tidbdeploy/tidb-4000
log_dir: /data/tidb/tidbdeploy/tidb-4000/log
tikv 扩容
[root@iZt4necvvu7hu3t950mf3cZ tidb]
global:
user: "root"
ssh_port: 22
deploy_dir: "/data/tidb/tidbdeploy"
data_dir: "/data/tidb/tidbdata"
arch: "amd64"
os: "linux"
tikv_servers:
- host: 192.168.222.153
ssh_port: 22
port: 20160
status_port: 20180
deploy_dir: "/data/tidb/tidbdeploy/tikv-20160"
data_dir: "/data/tidb/tidbdata/tikv-20160"
log_dir: "/data/tidb/tidbdeploy/tikv-20160/log"
arch: "amd64"
os: "linux"
- host: 192.168.222.154
ssh_port: 22
port: 20160
status_port: 20180
deploy_dir: "/data/tidb/tidbdeploy/tikv-20160"
data_dir: "/data/tidb/tidbdata/tikv-20160"
log_dir: "/data/tidb/tidbdeploy/tikv-20160/log"
arch: "amd64"
os: "linux"
- host: 192.168.222.155
ssh_port: 22
port: 20160
status_port: 20180
deploy_dir: "/data/tidb/tidbdeploy/tikv-20160"
data_dir: "/data/tidb/tidbdata/tikv-20160"
log_dir: "/data/tidb/tidbdeploy/tikv-20160/log"
arch: "amd64"
os: "linux"
grafana 扩容
[root@iZt4necvvu7hu3t950mf3cZ tidb]
global:
user: "root"
ssh_port: 22
deploy_dir: "/data/tidb/tidbdeploy"
data_dir: "/data/tidb/tidbdata"
arch: "amd64"
os: "linux"
grafana_servers:
- host: 192.168.222.154
ssh_port: 22
port: 3000
deploy_dir: "/data/tidb/tidbdeploy/grafana-3000"
arch: "amd64"
os: "linux"
prometheus 扩容
[root@iZt4necvvu7hu3t950mf3cZ tidb]
global:
user: "tidb"
ssh_port: 22
deploy_dir: "/data/tidb/tidbdeploy"
data_dir: "/data/tidb//tidbdata"
monitoring_servers:
- host: 192.168.222.154
集群进行缩容
集群整体情况
[root@localhost tidb]
+ /root/.tiup/bin/tiup cluster display tidb-cluster
Cluster type: tidb
Cluster name: tidb-cluster
Cluster version: v7.6.0
Deploy user: tidb
SSH type: builtin
Dashboard URL: http://192.168.222.152:2379/dashboard
Grafana URL: http://192.168.222.151:3000,http://192.168.222.154:3000
ID Role Host Ports OS/Arch Status Data Dir Deploy Dir
-- ---- ---- ----- ------- ------ -------- ----------
192.168.222.151:3000 grafana 192.168.222.151 3000 linux/x86_64 Up - /data/tidb/tidbdeploy/grafana-3000
192.168.222.154:3000 grafana 192.168.222.154 3000 linux/x86_64 Up - /data/tidb/tidbdeploy/grafana-3000
192.168.222.152:2379 pd 192.168.222.152 2379/2380 linux/x86_64 Up|UI /data/tidb/tidbdata/pd-2379 /data/tidb/tidbdeploy/pd-2379
192.168.222.155:2379 pd 192.168.222.155 2379/2380 linux/x86_64 Up|L /data/tidb/tidbdata/pd-2379 /data/tidb/tidbdeploy/pd-2379
192.168.222.151:9090 prometheus 192.168.222.151 9090/12020 linux/x86_64 Up /data/tidb/tidbdata/prometheus-9090 /data/tidb/tidbdeploy/prometheus-9090
192.168.222.150:4000 tidb 192.168.222.150 4000/10080 linux/x86_64 Up - /data/tidb/tidbdeploy/tidb-4000
192.168.222.153:4000 tidb 192.168.222.153 4000/10080 linux/x86_64 Up - /data/tidb/tidbdeploy/tidb-4000
192.168.222.150:20160 tikv 192.168.222.150 20160/20180 linux/x86_64 Up /data/tidb/tidbdata/tikv-20160 /data/tidb/tidbdeploy/tikv-20160
192.168.222.151:20160 tikv 192.168.222.151 20160/20180 linux/x86_64 Up /data/tidb/tidbdata/tikv-20160 /data/tidb/tidbdeploy/tikv-20160
192.168.222.152:20160 tikv 192.168.222.152 20160/20180 linux/x86_64 Up /data/tidb/tidbdata/tikv-20160 /data/tidb/tidbdeploy/tikv-20160
192.168.222.153:20160 tikv 192.168.222.153 20160/20180 linux/x86_64 Up /data/tidb/tidbdata/tikv-20161 /data/tidb/tidbdeploy/tikv-20161
192.168.222.154:20161 tikv 192.168.222.154 20161/20181 linux/x86_64 Up /data/tidb/tidbdata/tikv-20162 /data/tidb/tidbdeploy/tikv-20162
192.168.222.155:20162 tikv 192.168.222.155 20162/20182 linux/x86_64 Up /data/tidb/tidbdata/tikv-20163 /data/tidb/tidbdeploy/tikv-20163
Total nodes: 13
集群进行缩容
tiup cluster scale-in tidb-cluster --node=192.168.222.150:4000
tiup cluster scale-in tidb-cluster --node=192.168.222.150:20160
tiup cluster scale-in tidb-cluster --node=192.168.222.151:3000
tiup cluster scale-in tidb-cluster --node=192.168.222.151:9090
tiup cluster scale-in tidb-cluster --node=192.168.222.151:20160
tiup cluster scale-in tidb-cluster --node=192.168.222.152:2379
tiup cluster scale-in tidb-cluster --node=192.168.222.152:20160
清理节点
tiup cluster prune tidb-cluster
迁移集群管理软件
[root@localhost ~]
集群进行升级操作
配置tiup命令
echo 'export PATH=$PATH:/root/.tiup/bin' >> ~/.bashrc
source ~/.bashrc
升级 TiUP
tiup update --self
更新集群配置文件
tiup cluster edit-config tidb-cluster
执行升级
tiup cluster upgrade tidb-cluster v8.5.0
验证升级
tiup cluster display tidb-cluster