4

db for huge amount of iot data?

Comments
  • 1
    How much is huge? Any relational DB can handle millions and millions of rows...
    If you wanna search through it/analyze the data I'd recommend a NoSQL DB like elastic.
  • 0
    Iot data is usually time series. If the data rate is not high then influxdb or elastic good to go. If data rate is high you may need Kafka like stuff in between.
  • 0
    @Azer0s hundreds of billions rows, terabytes of data
  • 0
    mssql for that is kinda slow without ssd, but i didnt figured out partitioning old infrequently used data to be stored on hdd, like split one table between volumes
  • 1
    @MaxDeepfield Still not that much for a good relational db. MsSQL, Oracle or even MySQL can handle that. Terabytes is not big data, petabytes is.
  • 0
    A few weeks ago I read that mongoDb performs good on such dB sizes.
  • 0
    Just use text files 🙃
  • 1
    Blockchain, ofc. It’s 2018, get with it!
Add Comment