laravel主从读写分离配置

参考链接

在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' => [
            'driver'         => 'mysql',
            'url'            => env('DATABASE_URL'),
//            'port'            => env('DB_PORT', '3306'),
            'read'           => [
                'host'           => env('DB_HOST', '192.168.1.182'),
                'password'       => env('DB_PASSWORD', ''),
            ],
            'write'           => [
                'host'           => env('DB_HOST', '192.168.1.183'),
                'password'       => env('DB_PASSWORD', ''),
            ],
            'database'       => env('DB_DATABASE', 'forge'),
            'username'       => env('DB_USERNAME', 'forge'),
//            'password'       => env('DB_PASSWORD', ''),
            'unix_socket'    => env('DB_SOCKET', ''),
            'charset'        => 'utf8mb4',
            'collation'      => 'utf8mb4_unicode_ci',
            'prefix'         => '',
            'prefix_indexes' => true,
            'strict'         => true,

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

'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'        => env('DB_DATABASE', 'forge'),
    'unix_socket'     => env('DB_SOCKET', ''),
    'charset'         => 'utf8mb4',
    'collation'       => 'utf8mb4_unicode_ci',
    'prefix'          => '',
    'prefix_indexes'  => true,
    'strict'          => true,
]

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