- 某个业务使用的磁盘较小而且容量即将用完,因此将数据库目录更换到一个新的比较大的磁盘上,新的磁盘是对虚拟机动态添加的一块200G的磁盘,需要操作系统能够在不重启的情况下动态识别新添加的磁盘并将MySQL的数据目录进行备份并还原,即做到基本不影响业务的运行,本次使用XtraBacku,具体实现国学如下:
- 操作系统动态识别新硬盘:
host0/ host1/ host2/
Disk /dev/sda: 10.7 GB, 10737418240 bytes, 20971520 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x0006ca14
Device Boot Start End Blocks Id System
/dev/sda1 2048 2099199 1048576 82 Linux swap / Solaris
/dev/sda2 * 2099200 20971519 9436160 83 Linux
Disk /dev/sdb: 21.5 GB, 21474836480 bytes, 41943040 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x000c88d6
Device Boot Start End Blocks Id System
/dev/sdb1 2048 41943039 20970496 83 Linux
Disk /dev/sdc: 214.7 GB, 214748364800 bytes, 419430400 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
- 分区及格式化,也可以不分区直接使用的:
meta-data=/dev/sdc1 isize=256 agcount=4, agsize=13107136 blks
= sectsz=512 attr=2, projid32bit=1
= crc=0 finobt=0
data = bsize=4096 blocks=52428544, imaxpct=25
= sunit=0 swidth=0 blks
naming =version 2 bsize=4096 ascii-ci=0 ftype=0
log =internal log bsize=4096 blocks=25599, version=2
= sectsz=512 sunit=0 blks, lazy-count=1
realtime =none extsz=4096 blocks=0, rtextents=0
- 先临时挂在到某个路径:
- 安装XtraBackup并执行备份及还原:
datadir=/mnt/mysql
datadir=/data/mysql
- 配置磁盘开机自动挂载:
/dev/sdc1: UUID="7ec48cc7-7cb6-4f6b-83da-c8a831159c14" TYPE="xfs
UUID=7ec48cc7-7cb6-4f6b-83da-c8a831159c14 /data xfs defaults 0 0