weixin_39722188 2020-11-21 20:15
浏览 0

Changed to allow replication connection

This change allows replication connection.

When you want to use replication feature, you can set the flag in db.php.

 php
<?php return array(
    'default' => array(
        'connection'  => array(
            'dsn'        => 'mysql:host=localhost;dbname=default',
            'username'   => 'dbuser',
            'password'   => 'dbpass',
        ),
    ),
    'db1' => array(
        'type'        => 'pdo',
        'connection'  => array(
            'dsn'        => 'mysql:host=localhost;dbname=db1',
            'username'   => 'dbuser',
            'password'   => 'dbpass',
        ),
        'identifier'   => '`',
        'table_prefix' => '',
        'charset'      => 'utf8',
        'enable_cache' => true,
        'profiling'    => false,
    ),
    'db2' => array(
        'type'        => 'pdo',
        'connection'  => array(
            'dsn'        => 'mysql:host=localhost;dbname=db2',
            'username'   => 'dbuser',
            'password'   => 'dbpass',
        ),
        'identifier'   => '`',
        'table_prefix' => '',
        'charset'      => 'utf8',
        'enable_cache' => true,
        'profiling'    => false,
    ),
    'replication' => array(
        'enable' => true,
        'master' => array('db1'),
        'slave' => array('db1', 'db2'),
    )
);

Only Database_Query_Builder_Select uses the slave connection. And other queries use the master connection.

Respectively, specify the multiple connection name, the destination is a random lottery.

I want your opinion.

该提问来源于开源项目:fuel/core

  • 写回答

0条回答 默认 最新

    报告相同问题?