mysql 分区 扩充_mysql分区LVM扩容
大家好,又见面了,我是你们的朋友全栈君。
场景:mysql的数据库目录为/data随着数据量的增加,该分区不够用了,准备添加一块ssd硬盘,扩容该分区!
下面是测试环境的整个过程:
测试环境:在原有LVM卷标上添加一块50G的新硬盘对LVM进行扩容
1、将添加的新硬盘进行分区:
fdisk /dev/sda
WARNING: DOS-compatible mode is deprecated.
It’s strongly recommended to
switch off the mode (command ‘c’) and change display units to
sectors (command ‘u’).
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-6527, default 1):
Using default value 1
Last cylinder, +cylinders or +size{K,M,G}
(1-6527, default 6527):
Using default value 6527
Command (m for help): t
Selected partition 1
Hex code (type L to list codes): 8e
Changed system type of partition 1 to 8e
(Linux LVM)
Command (m for help): p
Disk /dev/sda: 53.7 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280
bytes
Sector size (logical/physical): 512 bytes /
512 bytes
I/O size (minimum/optimal): 512 bytes / 512
bytes
Disk identifier: 0xadc427e3
Device Boot Start End Blocks
Id System
/dev/sda1 1 6527
52428096 8e Linux LVM
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@lvm-test /]#fdisk -l
Disk /dev/sda: 53.7 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280
bytes
Sector size (logical/physical): 512 bytes /
512 bytes
I/O size (minimum/optimal): 512 bytes / 512
bytes
Disk identifier: 0xadc427e3
Device Boot Start End Blocks Id
System
/dev/sda1 1 6527
52428096 8e Linux LVM
Disk /dev/sdb:
21.5 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280
bytes
Sector size (logical/physical): 512 bytes /
512 bytes
I/O size (minimum/optimal): 512 bytes / 512
bytes
Disk identifier: 0x0000e547
Device Boot Start End Blocks
Id System
/dev/sdb1
* 1 26 204800
83 Linux
Partition 1 does not end on cylinder boundary.
/dev/sdb2 26 2611
20765696 8e Linux LVM
Disk /dev/sdc: 32.2 GB, 32212254720 bytes
255 heads, 63 sectors/track, 3916 cylinders
Units = cylinders of 16065 * 512 = 8225280
bytes
Sector size (logical/physical): 512 bytes /
512 bytes
I/O size (minimum/optimal): 512 bytes / 512
bytes
Disk identifier: 0x000468eb
Device Boot Start End Blocks
Id System
/dev/sdc1 1 3917
31456256 8e Linux LVM
Disk /dev/mapper/vg_lvmtest-LogVol00: 21.0
GB, 20971520000 bytes
255 heads, 63 sectors/track, 2549 cylinders
Units = cylinders of 16065 * 512 = 8225280
bytes
Sector size (logical/physical): 512 bytes /
512 bytes
I/O size (minimum/optimal): 512 bytes / 512
bytes
Disk identifier: 0x00000000
Disk /dev/mapper/vg_lvmtest-LogVol01: 32.5
GB, 32497467392 bytes
255 heads, 63 sectors/track, 3950 cylinders
Units = cylinders of 16065 * 512 = 8225280
bytes
Sector size (logical/physical): 512 bytes /
512 bytes
I/O size (minimum/optimal): 512 bytes / 512
bytes
Disk identifier: 0x00000000
2、新建PV:
[root@lvm-test /]# pvcreate
/dev/sda1
Writing physical volume data to disk “/dev/sda1”
Physical volume “/dev/sda1” successfully created
[root@lvm-test /]# pvscan
PV
/dev/sdb2 VG vg_lvmtest lvm2 [19.80 GiB / 0 free]
PV
/dev/sdc1 VG vg_lvmtest lvm2 [30.00 GiB / 0 free]
PV /dev/sda1 lvm2 [50.00 GiB]
Total: 3 [99.80 GiB] / in use: 2 [49.80 GiB] / in no VG: 1 [50.00 GiB]
3加大VG,利用vgextend功能
[root@lvm-test /]# vgextend
vg_lvmtest /dev/sda1
Volume group “vg_lvmtest” successfully extended
[root@lvm-test /]# vgdisplay
—
Volume group —
VG
Name vg_lvmtest
System ID
Format lvm2
Metadata Areas 3
Metadata Sequence No 4
VG
Access read/write
VG
Status resizable
MAX
LV 0
Cur
LV 2
Open LV 2
Max
PV 0
Cur
PV 3
Act
PV 3
VG
Size 99.79 GiB
PE
Size 4.00 MiB
Total PE 25547
Alloc PE / Size 12748 /
49.80 GiB
Free PE / Size 12799 / 50.00 GiB
VG
UUID
QJMQEA-k17Z-O8N8-wP3d-NsEu-G9fy-gUclGB
空闲的PE共有12799,容量为50G
4,利用lvresize来增加
[root@lvm-test /]#lvresize
-l +12799 /dev/vg_lvmtest/LogVol01
Extending logical volume LogVol01 to 80.26 GiB
Logical volume LogVol01 successfully resized
[root@lvm-test /]# lvdisplay
—
Logical volume —
LV
Path /dev/vg_lvmtest/LogVol01
LV
Name LogVol01
VG
Name vg_lvmtest
LV
UUID
ibxmqZ-1HPY-NpXz-KS1n-OzT0-XVa4-hNtvRS
LV
Write Access read/write
LV
Creation host, time lvm-test, 2013-08-15 16:12:22 +0800
LV
Status available
#
open 1
LV
Size 80.26 GiB
Current LE 20547
Segments 3
Allocation inherit
Read ahead sectors auto
–
currently set to 256
Block device 253:1
—
Logical volume —
LV
Path
/dev/vg_lvmtest/LogVol00
LV
Name LogVol00
VG
Name vg_lvmtest
LV
UUID
0h6qFC-Jqzf-7wnP-MAu3-jrMm-Da6D-YuaG8N
LV
Write Access read/write
LV
Creation host, time lvm-test, 2013-08-15 16:12:40 +0800
LV
Status available
#
open 1
LV
Size 19.53 GiB
Current LE 5000
Segments 1
Allocation inherit
Read ahead sectors auto
–
currently set to 256
Block device 253:0
上面执行完之后df -h并没有查看到增加的容量如下所示:
[root@lvm-test /]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_lvmtest-LogVol00
20G 975M
18G 6% /
tmpfs 939M 0
939M 0% /dev/shm
/dev/sdb1 194M 27M
158M 15% /boot
/dev/mapper/vg_lvmtest-LogVol01
30G 193M
29G 1% /data
5、执行最后一步操作:
[root@lvm-test /]# resize2fs
/dev/vg_lvmtest/LogVol01
resize2fs 1.41.12 (17-May-2010)
Filesystem at /dev/vg_lvmtest/LogVol01 is
mounted on /data; on-line resizing required
old desc_blocks = 2, new_desc_blocks = 6
Performing an on-line resize of
/dev/vg_lvmtest/LogVol01 to 21040128 (4k) blocks.
The filesystem on /dev/vg_lvmtest/LogVol01
is now 21040128 blocks long.
[root@lvm-test var]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_lvmtest-LogVol00
20G 992M
18G 6% /
tmpfs 939M 0
939M 0% /dev/shm
/dev/sdb1 194M 27M
158M 15% /boot
/dev/mapper/vg_lvmtest-LogVol01
80G 205M
75G 1% /data
该工具可以实现在线的扩容,不影响用户的使用!
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/151538.html原文链接:https://javaforall.cn
相关文章
- MySQL空间数据库:最佳解决方案(mysql空间数据库)
- MySQL Partitioning: Mastering the Syntax(mysql分区语法)
- MySQL的CRUD操作:增删改查的精髓(mysql的增删改查语句)
- MySQL数据库扩容:最佳实践(数据库扩容mysql)
- MySQL 如何重命名数据库(mysql重命名库)
- MySQL查看表分区的指南(mysql查看分区)
- 数据MySQL:轻松获取上周数据(mysql获取上周)
- 【MySQL企业版:最具性价比的报价】(mysql企业版报价)
- MySQL 二级分区:一种灵活的索引策略(mysql二级分区)
- MySQL中的非聚簇索引优势(mysql非聚簇索引)
- 限制MySQL中字符串长度的限制(mysql字符个数)
- MySQL 分片解决大数据存储问题(mysql分片分区)
- 如何查看MySQL的分区情况(mysql分区查看分区)
- MySQL分区表:建立、优化及使用(mysql建立分区)
- MySQL的Key Partitioning技术使用分析(mysql的key分区)
- MySQL分区查询优化技术研究(mysql分区查询语句)
- MySQL分区查询,提升大型数据查询效率(mysql分区的查询)
- MySQL实现数据分解分表和分区技术(mysql分表和分区)
- MySQL 当天备份方法及注意事项(mysql当天)
- 查看MySQL数据库所有信息的方法(查看mysql所有数据库)
- Mysql如何快速查询记录数(mysql查询记录数)
- MySQL中min函数用法详解(mysql中min)
- MySQL中JOIN语句的用法简介(mysql中jion)
- MySQL使用GROUP BY进行一列求和的函数(mysql一列求和函数)
- MySQL下载及安装教程快速掌握MySql下载及安装方法,更高效地使用MySql数据库(mysql下载了在哪)
- MySQL上传服务器时出现乱码问题原因和解决方法(mysql上传服务器乱码)
- 如何处理MySQL上传数据丢失问题(mysql上传数据后丢失)
- 解决MySQL无法储存中文问题(mysql不能储存中文)