Hello everyone
Quick backstory. We have 2 main programs, both of them are using SQL server on windows. We used Hyper-V, but it wasn't very fast, nor secure enogh (periodic backups). Both of these systems are crucial for our company, so the best way would be to have some sort of continuity of working even in case of failure.
We had quite a few servers: 2 x R610, 2 x R630, and we recently bought 1 x R640 (All consumer grade SATA SSD) - we have other VM's there as well.
We decided to go with Proxmox, created fresh Proxmox installations, configure cluster. As we went deeper and deeper we tried ZFS storage, then Ceph, but these consumer Grade SSD's can't keep up with the load, and right now it is working probably worse that if it was just server with Windows install on it and scheduled backups.
Decision was made, we bought another R640 with HBA controller and fresh set of Enteprise Grade SAS drives, we will also replace controllers and drives for our R640 and one of R630.
So we will have cluster of: 2 x R640 and 1/2 x R630, all with SAS drives. All of them have 2 x 10Gb SFP ports and normal 1Gb RJ45 ports, 1 SFP port on each can be used for ceph.
My question is how to properly choose and configure storage (ZFS, Ceph, or something else), VM's and all other important parameters this time, so we will have flawless experience and safe deployment.
Thanks
Kacper
Quick backstory. We have 2 main programs, both of them are using SQL server on windows. We used Hyper-V, but it wasn't very fast, nor secure enogh (periodic backups). Both of these systems are crucial for our company, so the best way would be to have some sort of continuity of working even in case of failure.
We had quite a few servers: 2 x R610, 2 x R630, and we recently bought 1 x R640 (All consumer grade SATA SSD) - we have other VM's there as well.
We decided to go with Proxmox, created fresh Proxmox installations, configure cluster. As we went deeper and deeper we tried ZFS storage, then Ceph, but these consumer Grade SSD's can't keep up with the load, and right now it is working probably worse that if it was just server with Windows install on it and scheduled backups.
Decision was made, we bought another R640 with HBA controller and fresh set of Enteprise Grade SAS drives, we will also replace controllers and drives for our R640 and one of R630.
So we will have cluster of: 2 x R640 and 1/2 x R630, all with SAS drives. All of them have 2 x 10Gb SFP ports and normal 1Gb RJ45 ports, 1 SFP port on each can be used for ceph.
My question is how to properly choose and configure storage (ZFS, Ceph, or something else), VM's and all other important parameters this time, so we will have flawless experience and safe deployment.
Thanks
Kacper