yii2数据库读写分离db配置

yii2数据库读写分离db配置

<?php
return [
    'class'     => 'yii\db\Connection',
    'charset'     => 'utf8',

    //多主多从
    'masters'        => [
            ['dsn' => 'mysql:host=localhost;dbname=master1','charset' => 'utf8',],
            ['dsn' => 'mysql:host=localhost;dbname=master2','charset' => 'utf8',],
    ],
    'masterConfig'    =>  [
           'username'     => 'root',
           'password'     => '',
           'attributes' => [
               // use a smaller connection timeout
               PDO::ATTR_TIMEOUT => 10,
          ],
    ],

    'slaves'        => [
            ['dsn' => 'mysql:host=localhost;dbname=slave1','charset' => 'utf8',],
            ['dsn' => 'mysql:host=localhost;dbname=slave2','charset' => 'utf8',],
            ['dsn' => 'mysql:host=localhost;dbname=slave3','charset' => 'utf8',],
    ],
    'slaveConfig'    =>  [
           'username'     => 'root',
           'password'     => '',
           'attributes' => [
               // use a smaller connection timeout
               PDO::ATTR_TIMEOUT => 10,
          ],
    ],

];
?>

View Code

 

posted on 2017-03-12 20:58 木子炜培先生 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/liadmin/p/6539306.html