PDO SELECT from SLAVE and INSERT into MASTER : <p>is there any chance to set in PDO settings that SELECT's will be executed on SLAVE DB server and Insert &amp; Update &amp; DELETE will be executed on MASTER DB server, or I need to create PHP handler to do that? </p>

<p>Situation: </p>

<p>We have <strong>Master</strong> - <strong>Master</strong> replication for MySQL. We are going to add two new servers so it will be - <strong>Master</strong>/<strong>Slave</strong> - <strong>Master</strong>/<strong>Slave</strong>. </p>

<p>I want to create some handling for <strong>SELECT</strong> queries. I want execute <strong>SELECT</strong> queries on <strong>SLAVE</strong> instead of <strong>MASTER</strong> and all <strong>UPADTE&amp;INSERT&amp;DELETE</strong> queries will be executed on <strong>MASTER</strong>. Is this possible with some setting? </p>

<p>Thanks!</p>
