title: Using a different MySql DB for write operations in CakePHP
body: <p>I need to scale my mysql RDS instance. I can launch read replicas in amazon RDS, but problem is that  the write operations won't work on read replicas. I need to redirect all the write operations (INSERT, UPDATE, DELETE) on master server somehow, and all the read operations on a read replica. </p>
  
  <p>RDS will take care of synchronizing the read replica with latest changes.</p>
  
  <p>is there any easy way to modify cake to execute all the write commands on a different DB? without changing the controllers or models?</p>
  
  <p>my existing server is not able to handle the connections and cpu spikes. already tried to upgrade it, but it did not work. </p>
  
  <p>I appreciate your help.
  Thank You.</p>