tidb数据库升级

原创于 2025-01-09 10:33:23 发布 · 213 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#tidb #数据库 #运维

数据库版本

tidb7.6.0 升级到 tidb8.5.0

集群整体架构

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]# cat tidb-cluster.yaml 
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

部署集群：

# 查看tidb版本
[root@localhost tidb]# tiup list tidb

# 部署
tiup cluster deploy tidb-cluster v7.6.0 tidb-cluster.yaml -u root

#  卸载集群
# tiup cluster destroy tidb-cluster

启动集群：

tiup cluster start tidb-cluster --init
# tiup cluster start tidb-cluster

查看集群状态：

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]# cat pd_scale_out_file.yaml
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
    
 # 进行扩容
 # tiup cluster scale-out tidb-cluster pd_scale_out_file.yaml -u root

tidb server 扩容

[root@iZt4necvvu7hu3t950mf3cZ tidb]# cat tidbserver_scale_out_file.yaml
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

 # 进行扩容
 # tiup cluster scale-out tidb-cluster tidbserver_scale_out_file.yaml -u root

tikv 扩容

[root@iZt4necvvu7hu3t950mf3cZ tidb]# cat tikv_scale_out_file.yaml
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"
    
 # 进行扩容
 # tiup cluster scale-out tidb-cluster tikv_scale_out_file.yaml -u root

grafana 扩容

[root@iZt4necvvu7hu3t950mf3cZ tidb]# cat grafana_scale_out_file.yaml
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"

 # 进行扩容
 # tiup cluster scale-out tidb-cluster grafana_scale_out_file.yaml -u root

prometheus 扩容

[root@iZt4necvvu7hu3t950mf3cZ tidb]# cat prometheus_scale_out_file.yaml
global:
  user: "tidb"
  ssh_port: 22
  deploy_dir: "/data/tidb/tidbdeploy"
  data_dir: "/data/tidb//tidbdata"
monitoring_servers:
  - host: 192.168.222.154

 # 进行扩容
 # tiup cluster scale-out tidb-cluster prometheus_scale_out_file.yaml -u root

集群进行缩容

集群整体情况

[root@localhost tidb]# sh -x statu-cat-tidb.sh 
+ /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 ~]# scp -r .tiup root@192.168.222.153:/root/

集群进行升级操作

192.168.222.153 主机上操作升级

配置tiup命令

echo 'export PATH=$PATH:/root/.tiup/bin' >> ~/.bashrc
source ~/.bashrc

升级 TiUP

tiup update --self

更新集群配置文件

# 若是没有，可以不用修改
tiup cluster edit-config tidb-cluster
# 在打开的配置文件中，修改 tidb 部分的版本为 v8.5.0。

执行升级

tiup cluster upgrade tidb-cluster v8.5.0

验证升级

tiup cluster display tidb-cluster