dbreplica0.euwest.azure ran out of disk space.
somerset is piling up WALs waiting on this machine to get space to apply them.
Instead of adding more disks to the current lvm, we should move the data to zfs.
dbreplica0.euwest.azure ran out of disk space.
somerset is piling up WALs waiting on this machine to get space to apply them.
Instead of adding more disks to the current lvm, we should move the data to zfs.
Status | Assigned | Task | ||
---|---|---|---|---|
Migrated | gitlab-migration | T2561 Sort out disk space on beaubourg / somerset | ||
Migrated | gitlab-migration | T2576 Migrate dbreplica0.euwest.azure to zfs |
[Unit] After=zfs-import.target Before=zfs-mount.target Wants=zfs-import.target [Service] Type=oneshot RemainAfterExit=true ExecStartPre=-zpool remove data sdb ExecStart=zpool add data cache sdb ExecStop=zpool remove data sdb [Install] WantedBy=multi-user.target
I've replaced zfs-cache-azure.service with the following:
[Unit] After=zfs-import.target Before=zfs-mount.target Wants=zfs-import.target [Service] Type=oneshot RemainAfterExit=true ExecStartPre=-zpool remove data /dev/disk/azure/resource ExecStart=zpool add data cache /dev/disk/azure/resource ExecStop=zpool remove data /dev/disk/azure/resource [Install] WantedBy=multi-user.target
(turns out the resource disk pops up as sda on this machine...)
For now, the machine is set up with the following layout:
I've followed the instructions on https://www.percona.com/live/17/sites/default/files/slides/PostgreSQL%20%2B%20ZFS%20Best%20Practices.pdf for the dataset tuning - slide 82 onwards
.This layout manages 300 MB/s write speeds, we'll see if that's enough...
The migration of the data to zfs is complete, and the database has been restarted.
The old LVM now needs to be cleaned up.