PHP实现的Mysql读写分离

核心提示： example.php<?php / *** mysql-rw-php version 0.1 @ 2009-4-16 *** code by hqlulu#gmail.com *** http:

example.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];
}
?>