About r-w spliting
Posted by:
bruce zuo
Date: June 16, 2011 11:15PM
Hi all:
Now we want to build a slave database server in China,the master is in USA.Using mysql replication to keep master-slave consistent,but there is a problem:"Delay".In php code ,there are some script like below:
$que= "insert into test values(100,200)";
$res = $dbw->query($que);
$que = "select id,name from test";
$res = $dbw->query($que);
When read point to slave,maybe can't get anything because "Delay",and then the logic has made a mistake.
Deal with this problem,we could modify PHP code ,when read and write all in one logic,connecting to master,other reads,connecting to slave.But this time,the web has already completed 80%,and team leader don't want modify php code,and ask me to solve this problem on database level.Mysql-proxy provide the function of w-r split,but when replication is not normal,it is also read on slave.
Our real intention is when page views from China,"China server" handle the request ,when page views from USA,"USA servr" handle the request.
Can you give me some suggest about my quesion?
Best Regards.
Bruce.