用mysql proxy来读写分离,读的时候不会报错,写的时候在终端就会显示
server default db:
client default db: cirs
syncronizing
写操作一次就会显示一次,如何解决呢?是不是要改rw-splitting.lua
server default db:
client default db: cirs
syncronizing
写操作一次就会显示一次,如何解决呢?是不是要改rw-splitting.lua
mysql_select_db('cirs',$link);
/*
$db_list = mysql_list_dbs($link); while ($row = mysql_fetch_object($db_list)) {
echo $row->Database . "<br/>";
}
*/ mysql_query("insert into t1 values ('666666')");
//mysql_query("delete from t1");
$result = mysql_query("select * from t1");
while($row = mysql_fetch_array($result)){
$rows[] = $row;
}
echo "<pre>";
print_r($rows);
echo "</pre>";个人认为是mysql_select_db('cirs',$link);被mysql_proxy指派带slave服务器执行,然后进行写操作时就会报错,认为master没选择数据库