Re:Principles of Sharding for Relational Databases
by grw_ on Wednesday August 09, 2017 @03:24PM
(#14972689)
Sorry if this is obvious, but why not use multiple drives?
[ Parent
| on HN ]
Re:Principles of Sharding for Relational Databases
by jajern on Wednesday August 09, 2017 @03:38PM
(#14972793)
Technically you can. You can run a SSD array in RAID5, 6 or 10, and lose a little bit of performance but get the capacity needed.
Re:Principles of Sharding for Relational Databases
by metaphorm on Wednesday August 09, 2017 @03:38PM
(#14972800)
because that is nearly a synonym for sharding?
or did you mean just use a large capacity RAID setup? that will probably work fine for a lot of situations but it can expensive and introduce more latency for certain types of operations (but that might not matter, depends on context).
Re:Principles of Sharding for Relational Databases
by gnaritas on Wednesday August 09, 2017 @05:27PM
(#14973807)
It's a server, you don't put databases on non RAID drives anyway, that'd be silly as the loss of a single drive would lose all your data. RAID setup isn't an option, it's how things are done by default for servers in order to ensure redundancy against a single disk failure.