MySQL 双机热备份查询和操作的问题？ [ 2.0 版本 ]

实际上，yii2已经为你想好了，你只管用即可~
主从配置举例：

'db'=>[
        'class' => 'yii\db\Connection',
        'charset' => 'utf8',

        'masters' => [ //主库列表  
            ['dsn' => 'mysql:host=xxx;dbname=yourdatabase',],
        ],
        'masterConfig' => [ //主库通用配置
            'username' => 'root',
            'password' => '123456',
            'attributes' => [
                PDO::ATTR_TIMEOUT => 5
            ]
        ],
        'slaves' => [ //从库列表  配置单项
            ['dsn' => 'mysql:host=yyy;dbname=yourdatabase',],
        ],
        'slaveConfig' => [ //从库通用配置
            'username' => 'root',
            'password' => '123456',
            'attributes' => [
                PDO::ATTR_TIMEOUT => 3
            ]
        ],
    ],