多數據源也就是多個數據庫 打開 config/database.php 第一個是mysql 第二個是mysql1調用時用Db::connection('mysql')->跟執行的方法調用時用Db::connection('mysql1')->跟執行的方法'mysql' => [/*讀寫分離*/'read' => ['host' => ['127.0.0.1'],],'write' => ['host' => ['127.0.0.1'],],'sticky' => true,'driver' => 'mysql','url' => env('DATABASE_URL'),//'host' => env('DB_HOST', '127.0.0.1'),'port' =>'3306','database' =>'ceshi11','username' =>'root','password' => 'root','unix_socket' => env('DB_SOCKET', ''),'charset' => 'utf8mb4','collation' => 'utf8mb4_unicode_ci','prefix' => '','prefix_indexes' => true,'strict' => true,'engine' => null,'options' => extension_loaded('pdo_mysql') ? array_filter([PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),]) : [],],'mysql1' => [/*讀寫分離*/'read' => ['host' => ['127.0.0.1'],],'write' => ['host' => ['127.0.0.1'],],'sticky' => true,'driver' => 'mysql','url' => env('DATABASE_URL'),//'host' => env('DB_HOST', '127.0.0.1'),'port' =>'3306','database' =>'huge','username' =>'root','password' => 'root','unix_socket' => env('DB_SOCKET', ''),'charset' => 'utf8mb4','collation' => 'utf8mb4_unicode_ci','prefix' => '','prefix_indexes' => true,'strict' => true,'engine' => null,'options' => extension_loaded('pdo_mysql') ? array_filter([PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),]) : [],],

總結

以上是生活随笔為你收集整理的laravel实现多数据源配置和读写分离的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。