Timeline for What DB engine should be used for a petabyte database?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 10, 2018 at 14:37 | vote | accept | rwallace | ||
| Sep 9, 2018 at 18:00 | history | tweeted | twitter.com/StackSoftRecs/status/1038849727612309504 | ||
| Sep 8, 2018 at 1:46 | answer | added | Nickolay | timeline score: 1 | |
| Sep 7, 2018 at 10:51 | comment | added | rwallace | @Nickolay Both are required, but it might be possible to set up two different databases. In that case, which tool would you recommend for each? | |
| Sep 6, 2018 at 21:43 | comment | added | Nickolay | Are you talking about OLTP (high rate of inserts/updates for individual rows) or analytical (few, heavy, mostly read-only) workloads? "Petabytes" implies historical data, while "programmers writing application code" and "never letting any errors slip through" suggests you're thinking of OLTP (which is usually sized in terms of the number of concurrent requests). Using the same instance (I'd say even tool) for both is a bad idea. | |
| Sep 5, 2018 at 17:42 | answer | added | NothingToSeeHere | timeline score: 2 | |
| Sep 5, 2018 at 13:20 | comment | added | Mawg | A great question! I don't have an answer, but I think that "distributed over several data centers" is key there. Personally, I would, by instinct, stick with a Relational Database, because indexing & efficiency are going to be very important as you scale, and I just don't feel that NoSql can handle that (but would be happy to be proved wrong). Personally, I would got for MySQL over Postgres, but for Postgres over NoSql. This is the correct site for Software Recommendations, but if you don't get any, try dba.stackexchange.com | |
| Sep 4, 2018 at 16:15 | review | First posts | |||
| Sep 4, 2018 at 16:24 | |||||
| Sep 4, 2018 at 16:12 | history | asked | rwallace | CC BY-SA 4.0 |