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
Post a Comment