当前位置:网站首页>Upgrade MySQL 5.1 to 5.66
Upgrade MySQL 5.1 to 5.66
2022-04-23 15:38:00 【franket】
stop it mysql
[root@upgrade-slave mysql]# /etc/init.d/mysql stop
Shutting down MySQL. [ OK ]
[root@upgrade-slave mysql]#
Create current snapshot
Easy to restore to the current state
[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 ~]#
Check mysql state
[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://yzsam.com/2022/04/202204231406039354.html
边栏推荐
- 函数(第一部分)
- Leetcode学习计划之动态规划入门day3(198,213,740)
- What if the server is poisoned? How does the server prevent virus intrusion?
- 布隆过滤器在亿级流量电商系统的应用
- 如果conda找不到想要安装的库怎么办PackagesNotFoundError: The following packages are not available from current
- For examination
- Demonstration meeting on startup and implementation scheme of swarm intelligence autonomous operation smart farm project
- 通过 PDO ODBC 将 PHP 连接到 MySQL
- 负载均衡器
- T2 iCloud日历无法同步
猜你喜欢
随机推荐
Leetcode学习计划之动态规划入门day3(198,213,740)
时序模型:门控循环单元网络(GRU)
What exactly does the distributed core principle analysis that fascinates Alibaba P8? I was surprised after reading it
Redis主从复制过程
一刷313-剑指 Offer 06. 从尾到头打印链表(e)
Explanation of redis database (I)
The El tree implementation only displays a certain level of check boxes and selects radio
Mysql database explanation (IX)
控制结构(二)
移动app测试如何进行?
ICE -- 源码分析
Connectez PHP à MySQL via aodbc
什么是CNAS认证?CNAS认可的软件测评中心有哪些?
Advantages, disadvantages and selection of activation function
[leetcode daily question] install fence
Mysql database explanation (VII)
c语言---字符串+内存函数
小程序知识点积累
码住收藏▏软件测试报告模板范文来了
Sword finger offer (1) -- for Huawei