title: Read slave, read-write master setup
body: <p>I have a Flask, SQLAlchemy webapp which uses a single mysql server. I want to expand the database setup to have a read-only slave server such that I can spread the reads between both master and slave while continuing to write to the master db server.</p>
  <p>I have looked at few options and I believe I can't do this with plain SQLAlchemy. Instead I'm planning to create 2 database handles in my webapp, one each for master and slave db servers. Then using a simple random value use either the master/slave db handle for &quot;SELECT&quot; operations.</p>
  <p>However, I'm not sure if this is the right way to go with using SQLAlchemy. Any suggestion/tips on how to pull this off?</p>