title: How to setup a script that automatically clones the DB every 2 hours?
body: <p>I'm planning to build a system that will have 30+ tables and 100+ million rows in a few of those. Going to use MySQL - InnoDB (any better alternative for this?)</p>
  
  <p>My scripts are going to add a couple of hundreds of thousands of clicks to the database every day. On the other hand, I'd like to do heavy database queries during the day as well.</p>
  
  <p>What I came us with is to have two different servers. Server A would take all the clicks and store them and Server B would work on retrieving the results.</p>
  
  <p>Question A: Is this the right approach to do? Question B: Is it possible to set up a script that's cloning the database over from Server A to Server B - so the data is semi-up to date?</p>
  
  <p>Edit: LEMP stack</p>