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(发邮件时,请将#更换为@)进行举报,并提供相关证据,一经查实,本站将立刻删除涉嫌侵权内容。