Best Disk/Volume setup for simple installation

[borpin]

I realised something today that should have been blindingly obvious; data should be stored outside the container. Doh!

I'm using Proxmox at home on an old laptop to run things like pi-hole, mosquito - not much data so not an issue. I'm also running InfluxDB and Postgresql - lots of data writes. I am seeing a high IOWait and suspect that this might be a contributing factor.

The question is, what would be the best volume setup to use for these databases? This is not a high resilience environment, it is a question of how to use the one HDD/SSD.

I have looked through the various storage types presented to me under storage and read through the Wiki (which appears to be out of date).

I think my options are Directory or LVM. I also think that I need to select 'Container' to store container data (not clear from Wiki).

Final question - how do I backup these data volumes/directories?

 

[Dunuin]

I'm using Proxmox at home on an old laptop to run things like pi-hole, mosquito - not much data so not an issue. I'm also running InfluxDB and Postgresql - lots of data writes. I am seeing a high IOWait and suspect that this might be a contributing factor.

The question is, what would be the best volume setup to use for these databases? This is not a high resilience environment, it is a question of how to use the one HDD/SSD.

If your iowait is too high you should run that DBs from the SSD. But keep in mind that all the small sync writes may kill your SSD quite fast if that is not a durable enterprise SSD.

I have looked through the various storage types presented to me under storage and read through the Wiki (which appears to be out of date).

Look here for storage info.

I think my options are Directory or LVM. I also think that I need to select 'Container' to store container data (not clear from Wiki).

Yes, "Container" is for Containers, "Container Template" for templates.

Final question - how do I backup these data volumes/directories?

I like rsync to backup folders. If you just want to backup LXCs (without the bind-mounted folders) you can use the Proxmox buildin Backup feature.

 

[bobmc]

I think your main issue is that you have a single storage device. This is the choke point and no partitioning and formatting choices will not make any real difference to performance.