How to use multiple databases in Laravel?

Ans: Laravel is flexible to provide its inbuilt support for the multiple databases. All you need to do is provide the connection details in config/database.php file.

return [

    'default' => env('DB_CONNECTION', 'mysql'),

    'connections' => [

        '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', ''),

            'charset' => 'utf8',

            'collation' => 'utf8_unicode_ci',

            'prefix' => '',

            'strict' => false,

            'engine' => null,

        ],

'mysqlOne' => [

            'driver' => 'mysql',

            'host' => env('DB_HOST_ONE', '127.0.0.1'),

            'port' => env('DB_PORT', '3306'),

            'database' => env('DB_DATABASE_ONE', 'forge'),

            'username' => env('DB_USERNAME_ONE', 'forge'),

            'password' => env('DB_PASSWORD_ONE', ''),

            'charset' => 'utf8',

            'collation' => 'utf8_unicode_ci',

            'prefix' => '',

            'strict' => false,

            'engine' => null,

        ],

];

Once this is done, you are allowed to create two base model class for each connection  and define the connection name in each of these models.

//BaseModel.php

protected $connection = 'mysql';

//BaseModelOne.php

protected $connection = 'mysqlOne';

You are also allowed to extend these models where you can create more models for tables in each DB.