如果有集群如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
[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]#
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。
本文系转载,前往查看
如有侵权,请联系 cloudcommunity@tencent.com 删除。