Laravel数据库读写分离配置的方法
配置范例
'mysql'=>[ 'driver'=>'mysql', 'write'=>[ 'host'=>'192.168.1.180', ], 'read'=>[ ['host'=>'192.168.1.182'], ['host'=>'192.168.1.179'], ], ... ]
或
'mysql'=>[ 'driver'=>'mysql', 'write'=>[ 'host'=>'192.168.1.180', ], 'read'=>[ 'host'=>［ '192.168.1.182', '192.168.1.179' ], ], ... ]
扩展配置范例
'mysql'=>[ 'driver'=>'mysql', 'write'=>[ 'host'=>'192.168.1.180', 'username'=>'write', 'password'=>'write', ], 'read'=>[ [ 'host'=>'192.168.1.182', 'username'=>'read1', 'password'=>'read1', ], [ 'host'=>'192.168.1.179', 'username'=>'read2', 'password'=>'read2', ], ], ... ]
或者
'mysql'=>[ 'driver'=>'mysql', 'write'=>[ 'host'=>'192.168.1.180', 'username'=>'write', 'password'=>'write', ], 'read'=>[ 'host'=>［ '192.168.1.179', '192.168.1.182', ], 'username'=>'read', 'password'=>'read', ], ... ]
公司数据库架构为一主多从，从库访问地址为唯一地址，该处方便负载均衡及扩展从库。所以最终线上采用的配置
'mysql'=>[ 'driver'=>'mysql', 'write'=>[ 'host'=>'192.168.1.180', 'username'=>'write', 'password'=>'write', ], 'read'=>[ 'host'=>'192.168.1.179' 'username'=>'read', 'password'=>'read', ], ... ]
代码分析
授人以鱼不如授人以渔，之所以配置如此灵活的原因，以及如何查找到这些配置方式。主要通过查找代码，分析代码；相关代码都在下面粘出，这里就不做解释了，代码能说明一切；
路径：vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php
代码：
classConnectionFactory
{
...
/**
*Getthereadconfigurationforaread/writeconnection.
*
*@paramarray$config
*@returnarray
*/
protectedfunctiongetReadConfig(array$config)
{
$readConfig=$this->getReadWriteConfig($config,'read');
if(isset($readConfig['host'])&&is_array($readConfig['host'])){
$readConfig['host']=count($readConfig['host'])>1
?$readConfig['host'][array_rand($readConfig['host'])]
:$readConfig['host'][0];
}
return$this->mergeReadWriteConfig($config,$readConfig);
}
...
/**
*Getaread/writelevelconfiguration.
*
*@paramarray$config
*@paramstring$type
*@returnarray
*/
protectedfunctiongetReadWriteConfig(array$config,$type)
{
if(isset($config[$type][0])){
return$config[$type][array_rand($config[$type])];
}
return$config[$type];
}
...
/**
*Mergeaconfigurationforaread/writeconnection.
*
*@paramarray$config
*@paramarray$merge
*@returnarray
*/
protectedfunctionmergeReadWriteConfig(array$config,array$merge)
{
returnArr::except(array_merge($config,$merge),['read','write']);
}
...
}
classArr
{
...
/**
*Getallofthegivenarrayexceptforaspecifiedarrayofitems.
*
*@paramarray$array
*@paramarray|string$keys
*@returnarray
*/
publicstaticfunctionexcept($array,$keys)
{
static::forget($array,$keys);
return$array;
}
...
/**
*Removeoneormanyarrayitemsfromagivenarrayusing"dot"notation.
*
*@paramarray$array
*@paramarray|string$keys
*@returnvoid
*/
publicstaticfunctionforget(&$array,$keys)
{
$original=&$array;
$keys=(array)$keys;
if(count($keys)===0){
return;
}
foreach($keysas$key){
$parts=explode('.',$key);
while(count($parts)>1){
$part=array_shift($parts);
if(isset($array[$part])&&is_array($array[$part])){
$array=&$array[$part];
}else{
$parts=[];
}
}
unset($array[array_shift($parts)]);
//cleanupaftereachpass
$array=&$original;
}
}
...
}
以上这篇Laravel数据库读写分离配置的方法就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持毛票票。
声明：本文内容来源于网络，版权归原作者所有，内容由互联网用户自发贡献自行上传，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任。如果您发现有涉嫌版权的内容，欢迎发送邮件至：czq8825#qq.com（发邮件时，请将#更换为@）进行举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。