title: magento mysql Master/Slave replication - Slave not used
body: <p>I set up a MySQL slave and added the neccessary code to /app/etc/local.xml:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;default_read&gt;
  &lt;connection&gt;
  &lt;host&gt;&lt;![CDATA[host]]&gt;&lt;/host&gt;
  &lt;username&gt;&lt;![CDATA[useronslave]]&gt;&lt;/username&gt;
  &lt;password&gt;&lt;![CDATA[secret]]&gt;&lt;/password&gt;
  &lt;dbname&gt;&lt;![CDATA[dbname]]&gt;&lt;/dbname&gt;
  &lt;active&gt;1&lt;/active&gt;
  &lt;/connection&gt;
  &lt;/default_read&gt;
  </code></pre>
  
  <p>problem is, it appears the slave machine is never used for requests (using mysql monitoring)</p>
  
  <p>PAT</p>