Larval 主从读写分离配置

在DB的连接工厂中找到以下代码
.../vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php

/** 
 * Get the read configuration for a read / write connection. 
 * 
 * @param  array  $config 
 * @return array 
 */  
protected function getReadConfig(array $config)  
{  
    $readConfig = $this->getReadWriteConfig($config, 'read');  

    return $this->mergeReadWriteConfig($config, $readConfig);  
}  

/** 
 * Get a read / write level configuration. 
 * 
 * @param  array $config * @param string $type * @return array */  protected function getReadWriteConfig(array $config, $type) {  if (isset($config[$type][0])) {  return $config[$type][array_rand($config[$type])]; }  return $config[$type]; } /** * Merge a configuration for a read / write connection. * * @param  array $config * @param  array $merge * @return array */ protected function mergeReadWriteConfig(array $config, array $merge) {  return array_except(array_merge($config, $merge), ['read', 'write']); } 

工厂类通过随机获取读DB配置来进行读取操作，由此可推出DB的配置应该如下

'mysql' => [  
    'write'    => [  
        'host' => '192.168.1.180',  
    ],  
    'read' => [ ['host' => '192.168.1.182'], ['host' => '192.168.1.179'], ], 'driver' => 'mysql', 'database' => 'database', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ] 

加强版，支持多主多从，支持独立用户名和密码，配置如下

'mysql' => [  
    'write'    => [  
        [
            'host' => '192.168.1.180',
            'username' => '', 'password' => '', ], ], 'read' => [ [ 'host' => '192.168.1.182', 'username' => '', 'password' => '', ], [ 'host' => '192.168.1.179', 'username' => '', 'password' => '', ], ], 'driver' => 'mysql', 'database' => 'database', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ] 

验证
开启MySQL的general-log，通过tail -f的方式监控log变化来确定配置是否生效

更多PHP相关技术请搜索千锋PHP，做真实的自己，用良心做教育。

互联网+时代，时刻要保持学习，携手千锋PHP,Dream It Possible。