首页 > 代码库 > laravel实现数据库读写分离配置或者多读写分离配置

laravel实现数据库读写分离配置或者多读写分离配置

config\database.php里

读写分离:
‘mysql‘ => array( ‘read‘ => array( ‘host‘ => ‘192.168.1.1‘, ), ‘write‘ => array( ‘host‘ => ‘196.168.1.2‘ ), ‘driver‘ => ‘mysql‘, ‘database‘ => ‘database‘, ‘username‘ => ‘root‘, ‘password‘ => ‘‘, ‘charset‘ => ‘utf8‘, ‘collation‘ => ‘utf8_unicode_ci‘, ‘prefix‘ => ‘‘,),

多读写分离:

‘mysql‘ => array(    ‘read‘ => array(        ‘host‘ => ‘192.168.1.1‘,
     ‘host‘ => ‘192.168.1.3‘,

), ‘write‘ => array( ‘host‘ => ‘196.168.1.2‘,
 ‘host‘ => ‘192.168.1.4‘,

), ‘driver‘ => ‘mysql‘, ‘database‘ => ‘database‘, ‘username‘ => ‘root‘, ‘password‘ => ‘‘, ‘charset‘ => ‘utf8‘, ‘collation‘ => ‘utf8_unicode_ci‘, ‘prefix‘ => ‘‘,),
 
 

laravel实现数据库读写分离配置或者多读写分离配置