load balance mysql
in order to improve the performance of the database queries, I would like to know how to modify the query function to do the following if I have Mysql server A and B.
if query command is "SELECT" then use server A.
if query command is "DELETE,UPDATE, or INSERT" then use server B.
As you can see server B is the master and A is the slave for read only.