Question

laravel数据库读写分离了，如何指定从写的数据库读取数据？

$id=DB::table('can_delete')->insertGetId(array('name'=>'zc'));
$pdo = DB::connection()->getPdo();
$data=DB::connection()->setPdo($pdo)->table('can_delete')->where('id',$id)->get();
print_r($data);

为什么这样不对啊，程序没有报错

Answer 1

\vendor\laravel\framework\src\Illuminate\Database\Connection.php
public function select($query, $bindings = [], $useReadPdo = true){}

$useReadPdo 执行查询语句时指定为false即可

Answer 2

自动就支持的，配置了read, write host就可以了