[PHP] 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变化来确定配置是否生效