当前位置:网站首页>mysql 5.1升级到5.66
mysql 5.1升级到5.66
2022-04-23 14:06:00 【franket】
停止mysql
[root@upgrade-slave mysql]# /etc/init.d/mysql stop
Shutting down MySQL. [ OK ]
[root@upgrade-slave mysql]#
创建当前快照
便于恢复到当前状态
[root@upgrade-slave ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_test_for_mysqlupgrade-lv_root
99G 3.4G 90G 4% /
tmpfs 63G 0 63G 0% /dev/shm
/dev/sda1 477M 62M 390M 14% /boot
/dev/mapper/vg_test_for_mysqlupgrade-lv_data
1.7T 927G 726G 57% /data
/dev/mapper/vg_test_for_mysqlupgrade-lv_home
50G 53M 47G 1% /home
/dev/mapper/vg_test_for_mysqlupgrade-lv_var
99G 302M 94G 1% /var
[root@upgrade-slave ~]# lvs
LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert
lv_data vg_test_for_mysqlupgrade -wi-ao---- 1.73t
lv_home vg_test_for_mysqlupgrade -wi-ao---- 50.00g
lv_root vg_test_for_mysqlupgrade -wi-ao---- 100.00g
lv_swap vg_test_for_mysqlupgrade -wi-ao---- 16.00g
lv_var vg_test_for_mysqlupgrade -wi-ao---- 100.00g
[root@upgrade-slave ~]# vgs
VG #PV #LV #SN Attr VSize VFree
vg_test_for_mysqlupgrade 1 5 0 wz--n- 2.18t 200.00g
[root@upgrade-slave ~]# lvcreate -L 150G -s -n lv_s_data /dev/vg_test_for_mysqlupgrade/lv_data
Logical volume "lv_s_data" created.
[root@upgrade-slave ~]# lvs
LV VG Attr LSize Pool Origin Data% Meta% Move Log Cpy%Sync Convert
lv_data vg_test_for_mysqlupgrade owi-aos--- 1.73t
lv_home vg_test_for_mysqlupgrade -wi-ao---- 50.00g
lv_root vg_test_for_mysqlupgrade -wi-ao---- 100.00g
lv_s_data vg_test_for_mysqlupgrade swi-a-s--- 150.00g lv_data 0.00
lv_swap vg_test_for_mysqlupgrade -wi-ao---- 16.00g
lv_var vg_test_for_mysqlupgrade -wi-ao---- 100.00g
[root@upgrade-slave ~]#
检查mysql状态
[root@upgrade-slave src]# ps faux | grep mysql
root 11270 0.0 0.0 103308 824 pts/1 S+ 21:22 0:00 | \_ grep mysql
root 136775 0.0 0.0 189236 3732 pts/2 S+ 20:58 0:00 | \_ sudo tail -f /var/lib/mysql/upgrade-slave.err
root 136889 0.0 0.0 100944 612 pts/2 S+ 20:58 0:00 | \_ tail -f /var/lib/mysql/upgrade-slave.err
root 137921 0.0 0.0 189236 3736 pts/3 S+ 20:59 0:00 \_ sudo tail -f /var/lib/mysql/upgrade-slave.err
root 137993 0.0 0.0 100944 608 pts/3 S+ 20:59 0:00 \_ tail -f /var/lib/mysql/upgrade-slave.err
[root@upgrade-slave src]# /etc/init.d/mysql status
MySQL is not running [FAILED]
[root@upgrade-slave src]#
版权声明
本文为[franket]所创,转载请带上原文链接,感谢
https://cloud.tencent.com/developer/article/1986101
边栏推荐
- log4j 输出日志信息到文件中
- 帆软中使用if else 进行判断-使用标题条件进行判断
- Autumn recruitment in 2021, salary ranking No
- 室内外地图切换(室内基于ibeacons三点定位)
- As a junior college student, I studied hard in closed doors for 56 days, won Ali offer with tears, five rounds of interviews and six hours of soul torture
- jsp学习1
- RobotFramework 之 文件上传和下载
- 关于Jmeter启动闪退问题
- 封装logging模块
- VMware Workstation 无法连接到虚拟机。系统找不到指定的文件
猜你喜欢
Check in system based on ibeacons
HyperBDR云容灾V3.2.1版本发布|支持更多云平台,新增监控告警功能
HyperMotion云迁移助力中国联通,青云完成某央企上云项目,加速该集团核心业务系统上云进程
Cdh6 based on CM management 3.2 cluster integration atlas 2 one
PySide2
As a junior college student, I studied hard in closed doors for 56 days, won Ali offer with tears, five rounds of interviews and six hours of soul torture
VMware Workstation 无法连接到虚拟机。系统找不到指定的文件
室内外地图切换(室内基于ibeacons三点定位)
帆软实现分页时第一行和最后两行冻结方式
Call wechat customer service applet
随机推荐
Some good articles on pthread multithreading
Can I compile the header file and source file of the template separately
VMware 15pro mounts the hard disk of the real computer in the deepin system
Wechat applet obtains login user information, openid and access_ token
pthread_self()为何重复了
Homebrew是什么?以及使用
按实际取,每三级分类汇总一次,看图知需求
烟雾传感器(mq-2)使用详细教程(基于树莓派3b+实现)
室内外地图切换(室内基于ibeacons三点定位)
帆软中使用if else 进行判断-使用标题条件进行判断
某政务云项目业务系统迁移调研实践
1到100号的灯开关问题
POI operation word template replaces data and exports word
FBS (fman build system) packaging
在MAC上安装mysql
nodejs通过require读取本地json文件出现Unexpected token / in JSON at position
Postman的安装使用及填坑心得
Nifi 快速安装及文件同步操作
服务器日志分析工具(识别,提取,合并,统计异常信息)
Essential difference between restful WebService and gSOAP webservice