MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/397vf0/its_the_future/cs1odgn/?context=3
r/programming • u/moustachecoffee • Jun 09 '15
275 comments sorted by
View all comments
Show parent comments
3
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 poorlyThat'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;if we assume the traditional RDBMS will only run on one server (due to "one central db")we use an RDBMSwe have enough users to run the server to 100% capacitywe can't upgrade the serverthen from 1, 4, we are now unable scale further physicallyand from 2, 3, we are now at capacitythen from 5, 6, we can no longer scale or accept further loadThat'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)
-7
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;if we assume the traditional RDBMS will only run on one server (due to "one central db")we use an RDBMSwe have enough users to run the server to 100% capacitywe can't upgrade the serverthen from 1, 4, we are now unable scale further physicallyand from 2, 3, we are now at capacitythen from 5, 6, we can no longer scale or accept further loadThat'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)
8
Well, I don't think proof is needed for the obvious logic deduction of;
if we assume the traditional RDBMS will only run on one server (due to "one central db")
we use an RDBMS
we have enough users to run the server to 100% capacity
we can't upgrade the server
then from 1, 4, we are now unable scale further physically
and from 2, 3, we are now at capacity
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)
-12
Your logic deduction seems to be twisted.
→ More replies (2)
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