php+mysql+mysql_proxy 问题

[chenzhidenghao]

用mysql proxy来读写分离，读的时候不会报错，写的时候在终端就会显示

server default db:
client default db: cirs
syncronizing


写操作一次就会显示一次，如何解决呢？是不是要改rw-splitting.lua

[chenzhidenghao]

	$link = mysql_connect('192.168.40.143:4040','root','123456');
	
	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没选择数据库

[chenzhidenghao]