MySQL PHP Write & Read Servers Separate

[danesc]

Guys,

 

I have two MySQL servers 5.0.77-log on different machines. One is the "master" and the other one is the "slave" with a replication happening real-time. Here is my question:

 

How do I configure my PHP scripts to use the Master for INSERT, UPDATE and the Slave for all SELECT statements?  My current configuration is setup to do all MySQL interactions with one server (Master) but now I want to separate the two.

 

Here is my current configuration... please help out with what the new configuration would be:

 

$database = "some_db_name";

$user = "some_username_here";

$pass = "some_password_here";

$host = "xx.xx.xx.xx";

$connection = mysql_connect( $host, $user, $pass ) or failed_connection( mysql_error() );

mysql_select_db( $database ) or failed_connection( mysql_error() );

 

 

Thank you in advance!

[Ken2k7]

Well I guess you can check for the first word in a SQL and choose the correct connection. Though I would restrict in the member to have only the permissions on master and slave respectively so they don't accidentally do something you don't want.

[danesc]

I'm looking into using mysql-proxy ... any one uses this? thoughts? Things to lookout for?

 

Thanks in advance

[fenway]

What's wrong with a db abstraction layer?