News for hackers. Stuff that matters.

A comment on Principles of Sharding for Relational Databases. Parent comment

Re:Principles of Sharding for Relational Databases by user5994461 on Wednesday August 09, 2017 @05:33PM (#14973859)
The thing is that 5TB of company data cannot reasonably be kept in JBOD on the cheapest drives you could find on Amazon.
[ Parent | on HN ]
Re:Principles of Sharding for Relational Databases by sigstoat on Wednesday August 09, 2017 @05:52PM (#14974052)
if you're insisting on using the cheapest drives on amazon, you probably can't fit 5TB of data into a small room worth of computers.

if you're a reasonable person, you buy 6 1TB samsung SSDs and stuff them into a single 2U case and you're done.

[ Parent | on HN ]
Re:Principles of Sharding for Relational Databases by user5994461 on Wednesday August 09, 2017 @07:13PM (#14974642)
And you're gonna cry when the RAID0/JBOD fails and you lose all your data.

Let's not pretend there is anything reasonable in this setup.

[ Parent | on HN ]
Re:Principles of Sharding for Relational Databases by gjjrfcbugxbhf on Thursday August 10, 2017 @02:26AM (#14976988)
Presumably your data is (1) mirrored to another similar server ready to replace in case of failure and (2) also regularly backed up to two off-site locations...
[ Parent | on HN ]
Re:Principles of Sharding for Relational Databases by icedchai on Wednesday August 09, 2017 @05:46PM (#14974004)
Why do you want the cheapest drives? Do you value your application data?
[ Parent | on HN ]