How about SingleStore for your database on 15G Dell PE Servers?
Fri, 02 Dec 2022 04:58:29 -0000
|Read Time: 0 minutes
How about SingleStore for your database on 15G Dell PE Servers?
Singlestore is a distributed relational database that was previously called MemSQL. It is well suited to analytics workloads. There are two data structure constructs available. First is the column store which is on disk. Disk is typically SSDs. Second is a row store that is in memory and essentially a key-value database. Yes you can have both types in the same db and join across the two different table types. Data for the column store is arranged in leaves where the low level detail is stored and aggregators which are summarized data structures. Clients use the aggregators for queries via SQL.
Singlestore uses the MySQL protocol which makes it compatible with anything that can connect to MySQL.
Customers choose this database when they have demanding high performance analytics needs. We have many large financial customers that are very happy with it.
So what does it look like with the latest 15G IceLake servers for Dell.
Although it could run on most any server the leading candidate would be a Dell PowerEdge R650 for db sizes up to 400TBu. Environments that have larger db needs would use a Dell PowerEdge R750.
ROTs
- Aggregators use single 25GbE NIC
- Leaf nodes use a single 10GbE NIC
- Aggregator nodes use about ¼ RAM & ¼ cores as leaf nodes
Other items
- RAID is optional but most customers elect it. The figures below assume RAID10.
- Use an m.2 BOSS card w/ a R1 pair of 480GB RI SSDs for the OS and software. They are now hot swappable.
- As for durability & cost reasons 99.99% of the time read intensive value SAS SSDs will be the right fit.
5TB Env
- 2 aggregators w/ 4 x 480GB RI SSD, 128GB RAM, 2 x 8c, 25GbE NIC
- 4 leaf nodes w/ 4 x 960GB RI SSD, 256GB RAM, 2 x 12c, 10GbE NIC
100TB Env
- 3 aggregators w/ 2 x 960GB RI SSD, 128GB RAM, 2 x 8c, 25GbE NIC
- 7 leaf nodes w/ 8 x 3.84TB RI SSD, 512GB RAM, 2 x 24c, 10GbE NIC
400TB Env
- 4 aggregators w/ 2 x 960GB RI SSD, 128GB RAM, 2 x 8c, 25GbE NIC
- 14 leaf nodes w/ 8 x 7.68TB RI SSD, 1024GB RAM, 2 x 28c, 10GbE NIC
If you need your Singlestore database on Dell PE Servers do let us know.