Principles of Sharding for Relational Databases

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 ]