Mysql读写分离--PHP实现
<?php
/****************************************
*** mysql-rw-php version 0.1 @ 2009-4-16
*** code by hqlulu#gmail.com
***?http://www.aslibra.com
***?http://code.google.com/p/mysql-rw-php/
*** code modify from class_mysql.php (uchome)
****************************************/
require_once('mysql_rw_php.class.php');
//rw info
$db_rw = array(
? 'dbhost'=>'www.aslibra.com',
? 'dbuser'=>'aslibra',
? 'dbpw'=>'www.aslibra.com',
? 'dbname'=>'test'
);
$db_ro = array(
? array(
??? 'dbhost'=>'www.aslibra.com:4306',
??? 'dbuser'=>'aslibra',
??? 'dbpw'=>'www.aslibra.com'
? )
);
$DB = new mysql_rw_php;
//connect Master
$DB->connect($db_rw[dbhost], $db_rw[dbuser], $db_rw[dbpw], $db_rw[dbname]);
//Method 1: connect one server
$DB->connect_ro($db_ro[0][dbhost], $db_ro[0][dbuser], $db_ro[0][dbpw]);
//Method 2: connect one server from a list by rand
$DB->set_ro_list($db_ro);
//send to rw
$sql = "insert into a set a='test'";
$DB->query($sql);
//send to ro
$sql = "select * from a";
$qr = $DB->query($sql);
while($row = $DB->fetch_array($qr)){
? echo $row[a];
}
?>
