title: Writing to one db while reading from another using DevExpress XPO
body: <p>Does anyone have any experience with working with DevExpress' XPO in an environment where the DB is replicated? From my <a href="https://stackoverflow.com/questions/1034538/backend-db-setup-for-an-app-with-geographically-diverse-users">previous question</a> here and one on serverfault, I think it's been decided that replication is the way to go. </p>
  
  <p>The <a href="http://dev.mysql.com/doc/refman/6.0/en/replication-solutions-scaleout.html" rel="nofollow noreferrer">MySQL docs</a> say that all writes need to happen on the master, and all reads have to come from the slave. This makes sense, but now it's a matter of setting up XPO to write to the master (far away), but read from the slave (local). </p>
  
  <p>I received a good <a href="http://community.devexpress.com/forums/p/77807/266254.aspx#266254" rel="nofollow noreferrer">response</a> on the DevExpress forums about how it could be done, which I intend to attempt, but I'm wondering if anyone HAS done it, and any insights/gotchas/references they would have.</p>