title: How to scale MySQL with multiple machines?
body: <p>I have a web app running LAMP. We recently have an increase in load and is now looking at solutions to scale. Scaling apache is pretty easy we are just going to have multiple multiple machines hosting it and round robin the incoming traffic. </p>
  
  <p>However, each instance of apache will talk with MySQL and eventually MySQL will be overloaded. How to scale MySQL across multiple machines in this setup? I have already looked at <a href="https://stackoverflow.com/questions/189903/scaling-solutions-for-mysql-replication-clustering">this</a> but specifically we need the updates from the DB available immediately so I don't think replication is a good strategy here? Also hopefully this can be done with minimal code change.</p>
  
  <p>PS. We have around a 1:1 read-write ratio.</p>