当前位置:网站首页>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
边栏推荐
- RecyclerView细节研究-RecyclerView点击错位问题的探讨与修复
- Chapter I review of e-commerce spike products
- 云迁移的六大场景
- postman批量生产body信息(实现批量修改数据)
- 数据库DbVisualizer Pro报文件错误,导致数据连接失败
- findstr不是内部或外部命令解决方法
- Oracle-数据泵使用
- VMware15Pro在Deepin系统里面挂载真机电脑硬盘
- 回顾2021:如何帮助客户扫清上云最后一公里的障碍?
- On the multi-level certificate based on OpenSSL, the issuance and management of multi-level Ca, and two-way authentication
猜你喜欢
随机推荐
某政务云项目业务系统迁移调研实践
nodejs通过require读取本地json文件出现Unexpected token / in JSON at position
教育行业云迁移最佳实践:海云捷迅使用HyperMotion云迁移产品为北京某大学实施渐进式迁移,成功率100%
关于云容灾,你需要知道这些
Oracle-数据泵使用
VMware 15pro mounts the hard disk of the real computer in the deepin system
CDH cluster integration Phoenix based on CM management
jacob打印word
Logging module
Can global variables be defined in header files
Wechat applet initializes Bluetooth, searches nearby Bluetooth devices and connects designated Bluetooth (I)
Can I compile the header file and source file of the template separately
sql中出现一个变态问题
Research on recyclerview details - Discussion and repair of recyclerview click dislocation
多云数据流转?云上容灾?年前最后的价值内容分享
使用itextpdf实现截取pdf文档第几页到第几页,进行分片
RecyclerView细节研究-RecyclerView点击错位问题的探讨与修复
POI operation word template replaces data and exports word
浅谈基于openssl的多级证书,Multi-level CA的签发和管理,以及双向认证
How QT designer adds resource files