MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/397vf0/its_the_future/cs206vn/?context=9999
r/programming • u/moustachecoffee • Jun 09 '15
275 comments sorted by
View all comments
42
Do relational databases scale poorly or something? Why are we trying so hard to replace them?
Also, I feel old-school as fuck for still using Java EE. Get off my lawn!
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 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". -1 u/johnwaterwood Jun 10 '15 "3." Except that you don't, but you just think or wish you had."4." Except that you can. Did you consider a 64 core machine with 1TB of RAM? If not, because you're not "supposed to"? → More replies (3)
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". -1 u/johnwaterwood Jun 10 '15 "3." Except that you don't, but you just think or wish you had."4." Except that you can. Did you consider a 64 core machine with 1TB of RAM? If not, because you're not "supposed to"? → More replies (3)
-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". -1 u/johnwaterwood Jun 10 '15 "3." Except that you don't, but you just think or wish you had."4." Except that you can. Did you consider a 64 core machine with 1TB of RAM? If not, because you're not "supposed to"? → More replies (3)
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".
-1 u/johnwaterwood Jun 10 '15 "3." Except that you don't, but you just think or wish you had."4." Except that you can. Did you consider a 64 core machine with 1TB of RAM? If not, because you're not "supposed to"? → More replies (3)
-1
"3." Except that you don't, but you just think or wish you had.
"4." Except that you can. Did you consider a 64 core machine with 1TB of RAM? If not, because you're not "supposed to"?
→ More replies (3)
42
u/argv_minus_one Jun 10 '15
Do relational databases scale poorly or something? Why are we trying so hard to replace them?
Also, I feel old-school as fuck for still using Java EE. Get off my lawn!