OneDB Disk/Volume Recommendations
This depends on the amount of data and workload you will have in your OneDB Database server. So every database system will be different. But if High thoughput is needed then we recommend SSD drives to be used. And for your NFS shred drive, spinning disks are ok to use.
Below is a priority of spaces to be setup with SSD if possible. This is not required but the
more spaces/volumes setup with SSD drives the better performance can be achieved with the
OneDB Database server.
| Space/Volume | Drive Type |
|---|---|
| Logical Log Dbspace | SSD drive(s) |
| High Volume space | SSD drive(s) |
| Temp Spaces | SSD drive(s) |
| Physical Log Dbspace | SSD drive(s) |
| Low volume space | SSD/Spinning drive(s) |
| RWM NFS | Spinning drive(s) |
The amount of disk space allocated to each of these spaces and volumes is dependent on the size of your data and workload. It is recommended that the RWM NFS volume be approx 3-5 times the size of the total dbspaces if you plan to use the automated backups. We retain 3 archives of the OneDB database server.
Note: It is important to note that you can use all spinning disks and if needed you can put all
spaces on a single volume, a separate volume is needed for the RWM NFS. These recommendations
are given to provide the best performance possible for a production system.