Hacker Newsnew | comments | ask | jobs | submitlogin
chrisbolt 1799 days ago | link | parent

How is sharding an attempt to evade using advanced features?


gaius 1799 days ago | link

Sharding is purely a method to work around lack of scalability features in the database itself.

-----

boundlessdreamz 1799 days ago | link

If you want to scale horizontally, how do you do it without sharding ?

There is a limit to vertical scaling and it becomes more and more expensive.

-----

gaius 1799 days ago | link

You don't need to sacrifice single-image to scale horizontally, and you haven't for years. Sharding was invented by IBM in the 80s and all the major vendors had abandoned it by the 90s.

-----

sandGorgon 1798 days ago | link

database newbie here - I always thought sharding was the only thing to do after your DB starts choking on the volume. I did not know there was any other way to go about it. Care to share any information on how you would scale DB (PGSql maybe) - any google keywords would be welcome as well

-----

gaius 1798 days ago | link

So the MySQL camp would have you believe. But a) a real database running a balanced workload scales far further on the same kit than MySQL anyway and b) then you go with active/active clustering (e.g. Oracle RAC). I personally work on a 30Tb database like this and I've seen people take it to >100Tb.

-----

moe 1798 days ago | link

A problem with shared-everything clusters like RAC is that they tend to scale poorly under write-heavy loads. Other problems would be the significant complexity, low predictability (esp. in terms of latency) and ofcourse the oracle tax.

It boils down to the old question of right-tool-for-the-job and a RAC cluster is not the right tool for most webapp scenarios.

-----




Lists | RSS | Bookmarklet | Guidelines | FAQ | DMCA | News News | Feature Requests | Bugs | Y Combinator | Apply | Library

Search: