How to solve different queries?

How can the mysql queries for reads and writes be sent to different servers?

• Imagine a scenario where there is a single mysql master database server and two slaves, one nearer to the primary and one in the local vicinity in order to reduce the query traffic. Now I would like any database updating queries(insert, update and deletes) to be directed to the master server and any reads to be directed to any of the slave servers. How can that be achieved? I use php for my application development

• Answer:

  PHP extension mysqlnd-ms can automatically or with hints detect and balance your read queries against a collection of defined slaves. See: http://php.net/manual/en/book.mysqlnd-ms.php specifically  http://www.php.net/manual/en/mysqlnd-ms.rwsplit.php For Java applications you would need to declare the transaction as read-only and at the transaction boundary the query is balanced. http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-replication-connection.html