编辑文件:config\database.php
'mysql' => [ 'driver' => 'mysql', //读写分离配置 'write' => [ 'host' => env('DB_WRITE_HOST', '127.0.0.1'), ], 'read' => [ //注意,下面是二唯数组,支持多组读库,laravel 会随机取一组 ['host' => env('DB_READ_HOST_1', '127.0.0.1')], ['host' => env('DB_READ_HOST_2', '127.0.0.1')], ], //下面是统一配置,如果有不同,需要写到上面去 'port' => env('DB_PORT', '3306'), 'database' => env('DB_DATABASE', 'forge'), 'username' => env('DB_USERNAME', 'forge'), 'password' => env('DB_PASSWORD', ''), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => 'phpriji_', 'strict' => true, 'engine' => null, ],