mysql 5.1升级到5.61

franket

发布于 2022-04-16 09:43:38

23700

代码可运行

文章被收录于专栏：技术杂记技术杂记

运行总次数：0

代码可运行

停止集群

如果有集群如mha，要停止集群，因为备份结束时会产生一个长锁，集群软件侦测到一定时间里没响应会认为master发生了故障，从而触发迁移，这不是我们想看到的~因为这会导致新恢复出来的数据不一致

所以有集群的情况下，最好停止集群

Tip: 如果是mha，可以参考以下命令

masterha_check_status --conf=/etc/app1.cnf
masterha_stop  --conf=/etc/app1.cnf

开始备份

[root@upgrade-master ~]# time nohup /usr/bin/innobackupex --defaults-file=/etc/my.cnf  --user=root --password=xxxxxxxx  /mnt/mysqlbak/masterdb.full.backup  >> /tmp/masterdb.full.backup.log  2>&1   & 
[1] 890
[root@upgrade-master ~]#

下载两种版本mysql

分别下载同版本mysql，和目标版本(高版本)mysql

[root@upgrade-slave src]# yumdownloader  Percona-Server-client-51.x86_64   Percona-Server-devel-51.x86_64 Percona-Server-server-51.x86_64  Percona-Server-shared-51.x86_64  ; yumdownloader Percona-Server-client-56.x86_64 Percona-Server-devel-56.x86_64  Percona-Server-server-56.x86_64  Percona-Server-shared-56.x86_64  
Loaded plugins: fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
 * base: mirrors.btte.net
 * extras: mirrors.opencas.cn
 * updates: mirror.bit.edu.cn
Percona-Server-client-51-5.1.73-rel14.12.624.rhel6.x86_64.rpm                                     | 920 kB     00:18     
Percona-Server-devel-51-5.1.73-rel14.12.624.rhel6.x86_64.rpm                                      | 6.3 MB     01:01     
Percona-Server-server-51-5.1.73-rel14.12.624.rhel6.x86_64.rpm                                     |  12 MB     02:16     
Percona-Server-shared-51-5.1.73-rel14.12.625.rhel6.x86_64.rpm                                     | 2.1 MB     00:12     
Loaded plugins: fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
 * base: mirrors.btte.net
 * extras: mirrors.opencas.cn
 * updates: mirror.bit.edu.cn
Percona-Server-client-56-5.6.27-rel75.0.el6.x86_64.rpm                                            | 6.4 MB     01:27     
Percona-Server-devel-56-5.6.27-rel75.0.el6.x86_64.rpm                                             | 1.0 MB     00:06     
Percona-Server-server-56-5.6.27-rel75.0.el6.x86_64.rpm                                            |  20 MB     03:51     
Percona-Server-shared-56-5.6.27-rel75.0.el6.x86_64.rpm                                            | 725 kB     00:16     
[root@upgrade-slave src]# echo $?
0
[root@upgrade-slave src]#