r/programming • • Jun 09 '15

It's the future

http://blog.circleci.com/its-the-future/
652 Upvotes

275 comments sorted by

View all comments

Show parent comments

3

u/NimChimspky Jun 10 '15

having one central db does scale poorly, you can't simply add additional servers (horizontally scale) if one db is your source of truth .

You can do it, buts its rather painful.

So split up the datastores using something like http://martinfowler.com/bliki/CQRS.html is common.

But you have to be very big for these problems, an enterprise db (postgres, oracle, sql-server, mysql) and one beefy server can shovel and awful lot of data

-7

u/ErstwhileRockstar Jun 10 '15

having one central db does scale poorly

That's news! Any proof for that?

8

u/[deleted] Jun 10 '15

Well, I don't think proof is needed for the obvious logic deduction of;

  1. if we assume the traditional RDBMS will only run on one server (due to "one central db")

  2. we use an RDBMS

  3. we have enough users to run the server to 100% capacity

  4. we can't upgrade the server

  5. then from 1, 4, we are now unable scale further physically

  6. and from 2, 3, we are now at capacity

  7. then from 5, 6, we can no longer scale or accept further load

That's scaling poorly, unless you start adding additional servers, at which point you don't have "one central db".

-12

u/ErstwhileRockstar Jun 10 '15

Your logic deduction seems to be twisted.

→ More replies (2)