php - Yii2如何主从连接

Question

我配置了 MySQL 主从复制。

如何配置 Yii2 Active Record 在主数据库上插入、更新和删除查询以及在从数据库上读取查询？

Answer 1

Yii2 会自动处理这个问题，允许您配置多个从站甚至多个主站。

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

    // configuration for the master
    'dsn' => 'dsn for master server',
    'username' => 'master',
    'password' => '',

    // common configuration for slaves
    'slaveConfig' => [
        'username' => 'slave',
        'password' => '',
        'attributes' => [
            // use a smaller connection timeout
            PDO::ATTR_TIMEOUT => 10,
        ],
    ],

    // list of slave configurations
    'slaves' => [
        ['dsn' => 'dsn for slave server 1'],
        ['dsn' => 'dsn for slave server 2'],
        ['dsn' => 'dsn for slave server 3'],
        ['dsn' => 'dsn for slave server 4'],
    ],
]

链接到 Yii2 指南中的部分以获取更多信息:http://www.yiiframework.com/doc-2.0/guide-db-dao.html#read-write-splitting