[Roos DB] - Decide on filesystem options for data partition #324

New Issue

Closed

opened 2022-09-19 22:25:03 +02:00 by muppeth · 4 comments

muppeth commented

2022-09-19 22:25:03 +02:00

Owner

We have decided to go for xfs as in the future we might be utilizing GlusterFS if we expand operations.

To get the most optimal performance for db operations we need to make sure we go for best possible options.

We have decided to go for xfs as in the future we might be utilizing GlusterFS if we expand operations. To get the most optimal performance for db operations we need to make sure we go for best possible options.

muppeth added this to the 9.22 - September milestone 2022-09-19 22:25:03 +02:00

muppeth commented

2022-09-24 00:07:58 +02:00

Author

Owner

good starting point is of course arch wiki: https://wiki.archlinux.org/title/XFS

Although the defaults should be sufficient we need to check and tweak stuff because of hardware RAID being used and when using for db.

good starting point is of course arch wiki: https://wiki.archlinux.org/title/XFS Although the defaults should be sufficient we need to check and tweak stuff because of hardware RAID being used and when using for db.

muppeth commented

2022-09-24 00:38:27 +02:00

Author

Owner

Defults detected by the system:

OS/Containers:
RAID1, 447GB, 512bytes Block size, 6Gbps, 2xM.2
attr2,inode64,logbufs=8,logbsize=32k,noquota

DB Data:
RAID10, 3.491TB, 8GB Cache, 512bytes Block size, SAS, 12Gbps, 12xSAS
attr2,inode64,logbufs=8,logbsize=256k,sunit=512,swidth=2048,noquota

Defults detected by the system: OS/Containers: RAID1, 447GB, 512bytes Block size, 6Gbps, 2xM.2 attr2,inode64,logbufs=8,logbsize=32k,noquota ---- DB Data: RAID10, 3.491TB, 8GB Cache, 512bytes Block size, SAS, 12Gbps, 12xSAS attr2,inode64,logbufs=8,logbsize=256k,sunit=512,swidth=2048,noquota

muppeth commented

2022-09-24 00:59:32 +02:00

Author

Owner

I did some fio benching but perhaps setting up phoronix server will give much more results and also make it easier to put the data together for comparision of different options (also could compare performance of all servers).

muppeth commented

2022-10-04 16:23:09 +02:00

Author

Owner

Below attached some of the benchmarks. As always wit benchmarks, the differences are small and most probably affected by other things. Basically we can settle on default xfs settings as those seem to properly detect raid stripe size etc. As for other settings it's basically mount options so those can be tweaked on each reboot.

I therefore close this issue now and proceed to install OS and prepare for container deployments.

result-phoronix.pdf

443 KiB

muppeth closed this issue

2022-10-04 16:23:09 +02:00