Shrinking logical volume (LVM) must go through several steps. Unlike standard partition (ext4 file system). In order to shrink root logical volume, we must boot into a live CD like SystemRescueCD. And then shrink the volume from there.
Qcow2 file grows overtime; even if we delete files and snapshots. It still does not reduce the file size. The only way to that is to fill the disk with zero and then convert the disk to qcow2.
Doing MySQL load balancing on HAProxy has several advantages; such as ip address restriction. Configuring MySQL to use HAProxy proxy protocol is a ticky part. It needs to know HAProxy ip address.