1 year ago

Out of the box Laravel always you to have read/write database connections. This will allow you have different database connections for SELECT queries and INSERT, UPDATE and DELETE queries.

'mysql' => [ 'driver' => 'mysql', 'host' => env('DB_HOST', '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' => '', 'strict' => true, 'engine' => null, ], To have a different connection used for read queries you need to add a new read item to the config. https://paulund.co.uk/laravel-read-write-database-connections#replication-lagWith database setups like this there will need to be some database replication that will copy the database records from the write database to the read database.

Now you can have multiple database connections with your Laravel application.