load balance mysql

[letmein]

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.

[Chuck S]

Sorry I dont run load balanaced mysql servers so I cant really bring anything to the discussion but this.

You would need to hand modify every query in the program to select the proper database if thats how you want to do things

Good luck. Most load balanced servers though do not do what you want to do. They run normal and before switching actually do a sync with the other database then load and use that one.