PHP实现的mysql读写分离操作示例

首先mysql主从需配置好，基本原理就是判断sql语句是否是select，是的话走master库，否则从slave查

 

/**
* mysql读写分离
* edit: hyb
*/
class db 
{ 
public function __construct($sql) 
{ 
$chestr = strtolower(trim($sql));
if(substr($chestr,0,6)=='select') 
{ 
echo 'select db..<br>';
$link = mysql_connect("127.0.0.1:3306", "root", "root") or die("Could not connect: " . mysql_error()); 
mysql_select_db("test"); 
$result = mysql_query($sql); 
while ($row = mysql_fetch_array($result, MYSQLI_ASSOC)) 
{ 
echo $row['username'].'<br>';
} 
echo mysql_get_host_info($link).'<br>'; 
} 
else
{ 
echo 'insert db..<br>';
$link = mysql_connect("localhost:3306","root","root") or die("Could not connect: " . mysql_error()); 
mysql_select_db("test"); 
mysql_query($sql); 
echo @mysql_affected_rows().'<br>'; 
echo mysql_get_host_info($link).'<br>'; 
} 

} 
} 

$write = new db(" update think_user set logintime='12345' where id=5"); 
$read = new db("SELECT * from think_user");