4 ms·
Out of curiosity - what kind of hardware are you running on?
by dman 12y ago
Out of curiosity - what kind of hardware are you running on?
- bsg75 12y agoProduction would be Supermicro servers (8-16 CPU, 48/96/128GB RAM), with either banks of 10K RPM SATA drives, or a mix of SSD volumes and HDDs. All RAID-10. Some servers are SSD only (< 8TB) that are used for current period (month / quarter) for add-hoc queries of actively changing data. The mixed configs use the SSD volumes for staging and ETL processing (aggregation for storage into fact tables), as well as frequently queried current period data. As data periods age, they are migrated to HDD volumes which hold more data at a lower price point. My budget does not yet support 20+ TB of all SSD storage.