logging - Is a mySQL relational database scalable for holding 80 GBs of additional logs per day? -


i deciding on long term architecture solution storing dns logs. amount of data talking numbers 80 gbs of logs per day @ peak. looking @ nosql databases such mongodb, relational - mysql. want structure solution has 3 requirements:

  • storage: long term project, want necessary capability store 80 gbs of logs per day (~30 tb year!). realize pretty ridiculous, i'm willing have retention period (keep 6 months' worth of logs = 15 tb constant).
  • scalability: long term solution, big issue. i've heard mongodb horizontally scalable, while mysql not? elaboration on received.
  • query speed: close instantaneous querying possible.

it should noted our logs stored on intermediary server, not need forward logs our dns servers.


Comments

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -