title: For audit logging, which technique is the best?
body: <p>I need to choose a technique to store and retrieve the auditing logs(when something was added, deleted, modified, etc). The scenario is : the logs may be increased by 10 million per day and will be retrieved by some key words. 
  So my question is:</p>
  
  <ul>
  <li>which techique should I use, such as <strong>ELK</strong>(Elasticsearch, Logstash, Kibana ) or <strong>MySQL</strong> or <strong>Redis</strong> or something better and why.</li>
  </ul>