[-] Roland_Bodel_the_2nd@alien.top 1 points 11 months ago

I think what you want to do is go into your db vm and run a DD or fio or bonnie++ that is at least 2 x the VM RAM, and see what the steady-state disk performance is.

[-] Roland_Bodel_the_2nd@alien.top 1 points 11 months ago

15-30ms latency seems reasonable for that hardware (P420 in RAID 10 with 4x4TB 7k SAS HDDs.)

Basically your single SAS disk can do ~150IOPS random, so worst case of 4k random reads you will get ~600KBps.

For the migration if it's sequential (depending on filesystem layout), the performance can be different, up to maximum streaming performance of like 100MBs for large sequential reads.

Then 2x for your RAID config.

[-] Roland_Bodel_the_2nd@alien.top 1 points 11 months ago

Start with the cheapest suitable switch and go from there.

IMHO DDR3 is too old to be worth it unless you get the RAM for free

Roland_Bodel_the_2nd

joined 1 year ago