Hello everyone,
I need a couple of clarifications on installing DB/WAL devices with Ceph.
First, I'll quickly describe my current configuration:
My Proxomox 9.1 cluster of 3 nodes has a Ceph volume with a 10Gbit network, based on mechanical HDDs, and I would like to improve a bit the performances for VMs that have applications SQL based by adding 2 SAS SSDs for each node.
The 3 nodes are identical, based on Dell R740, with 24 2.5" slots, 10 of which are filled with 10 1TB SAS HDDs.
Clearly, each node has one OSD for each HDD, so 10 OSDs per node.
Now the questions:
1) For installation, in order to avoid problems with the device name, also thinking about a future where I might add other HDDs, do you think it is appropriate to install the SSDs in the first slots, i.e., slots 1 and 2 (and then move the HDDs to the subsequent slots at the end), or does it not matter?
2) Since I am adding db/wal to a working cluster, I will have to delete one OSD at a time.
When recreating the OSD, should I point db/wal to the SSD, only as a device? E.g., /dev/sdb and/or /dev/sdc (see screenshot below)
or should I first divide the device into N partitions? In my case, 5 partitions per SSD?
Thank you anyone who has already done something similar and can clarify my doubts.
I need a couple of clarifications on installing DB/WAL devices with Ceph.
First, I'll quickly describe my current configuration:
My Proxomox 9.1 cluster of 3 nodes has a Ceph volume with a 10Gbit network, based on mechanical HDDs, and I would like to improve a bit the performances for VMs that have applications SQL based by adding 2 SAS SSDs for each node.
The 3 nodes are identical, based on Dell R740, with 24 2.5" slots, 10 of which are filled with 10 1TB SAS HDDs.
Clearly, each node has one OSD for each HDD, so 10 OSDs per node.
Now the questions:
1) For installation, in order to avoid problems with the device name, also thinking about a future where I might add other HDDs, do you think it is appropriate to install the SSDs in the first slots, i.e., slots 1 and 2 (and then move the HDDs to the subsequent slots at the end), or does it not matter?
2) Since I am adding db/wal to a working cluster, I will have to delete one OSD at a time.
When recreating the OSD, should I point db/wal to the SSD, only as a device? E.g., /dev/sdb and/or /dev/sdc (see screenshot below)
or should I first divide the device into N partitions? In my case, 5 partitions per SSD?
Thank you anyone who has already done something similar and can clarify my doubts.