Technical Tip: How to extend a clickhouse DB disk

The requirement is to extend clickhouse hot tier disk /data-clickhouse-hot-1 of a clickhouse node (Supervisor or workers), then the following steps can be performed.

1. Increase the size of an existing disk mounted on /data-clickhouse-hot-1 from the hypervisor. It is /dev/sde for this example:

# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 25G 0 disk
├─sda1 8:1 0 1G 0 part /boot
└─sda2 8:2 0 24G 0 part
├─rl-swap 253:0 0 2.5G 0 lvm [SWAP]
└─rl-root 253:1 0 21.5G 0 lvm /
sdb 8:16 0 100G 0 disk
├─sdb1 8:17 0 22.4G 0 part [SWAP]
└─sdb2 8:18 0 68.9G 0 part /opt
sdc 8:32 0 60G 0 disk
└─sdc1 8:33 0 60G 0 part /svn
sdd 8:48 0 60G 0 disk
└─sdd1 8:49 0 60G 0 part /cmdb
sde 8:64 0 100G 0 disk /data-clickhouse-hot-1

2. Run the command on the clickhouse node to extend the file system of the disk:

# xfs_growfs /data-clickhouse-hot-1

3. Verify that the size of the disk has been extended.

# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 12G 0 12G 0% /dev
tmpfs 12G 40K 12G 1% /dev/shm
tmpfs 12G 281M 12G 3% /run
tmpfs 12G 0 12G 0% /sys/fs/cgroup
/dev/mapper/rl-root 22G 11G 11G 51% /
/dev/sdd1 60G 907M 60G 2% /cmdb
/dev/sdc1 60G 461M 60G 1% /svn
/dev/sdb2 69G 18G 52G 26% /opt
/dev/sda1 1014M 714M 301M 71% /boot
tmpfs 2.4G 0 2.4G 0% /run/user/500
/dev/sde 100G 2.6G 98G 3% /data-clickhouse-hot-1
tmpfs 2.4G 0 2.4G 0% /run/user/0

Similarly, it is possible to extend clickhouse warm or cold-tier disks:

/data-clickhouse-warm-1

/data-clickhouse-cold-1