In Laravel 5.1, you specify the connection:

$users = DB::connection('foo')->select(...);

By default, Laravel uses the default connection. Pretty simple, isn't it?

Read more here:http://laravel.com/docs/5.1/database#Visit the connection

From the Laravel Documentation: You can access each connection when using multiple connections, through theDBconnection method on the appearance. The name passed to the connection method should correspond to one of the connections listed in theconfig/database.phpconfiguration file:

$users = DB::connection('foo')->select(...);

Define connection

Use.env>= 5.0 (or higher)

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=mysql_database DB_USERNAME=root DB_PASSWORD=secret DB_CONNECTION_PGSQL=pgsql DB_HOST_PGSQL=127.0.0.1 DB_PORT_PGSQL=5432 DB_DATABASE_PGSQL=pgsql_database DB_USERNAME_PGSQL=root DB_PASSWORD_PGSQL=secret

Useconfig/database.php

'mysql' => [ 'driver' => env('DB_CONNECTION'), 'host' => env('DB_HOST'), 'port' => env('DB_PORT'), 'database' => env('DB_DATABASE'), 'username' => env('DB_USERNAME'), 'password' => env('DB_PASSWORD'), ], 'pgsql' => [ 'driver' => env('DB_CONNECTION_PGSQL'), 'host' => env('DB_HOST_PGSQL'), 'port' => env('DB_PORT_PGSQL'), 'database' => env('DB_DATABASE_PGSQL'), 'username' => env('DB_USERNAME_PGSQL'), 'password' => env('DB_PASSWORD_PGSQL'), ],

No.env

app/config/database.php

return array( 'default' => 'mysql', 'connections' => array( # Primary/Default database connection 'mysql' => array( 'driver' => 'mysql', 'host' => '127.0.0.1', 'database' => 'mysql_database', 'username' => 'root', 'password' => 'secret' 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ), # Secondary database connection 'pgsql' => [ 'driver' => 'pgsql', 'host' => 'localhost', 'port' => '5432', 'database' => 'pgsql_database', 'username' => 'root', 'password' => 'secret', 'charset' => 'utf8', 'prefix' => '', 'schema' => 'public', ] ), );

Architecture/Migration

Run theconnection()method to specify the connection to use.

Schema::connection('pgsql')->create('some_table', function($table) { $table->increments('id'): });

Alternatively, define a connection at the top.

protected $connection = 'pgsql';

Query Builder

$users = DB::connection('pgsql')->select(...);

model

(In Laravel >= 5.0 (or higher))

Set$connectionVariables

in the model

class ModelName extends Model { // extend changed protected $connection = 'pgsql'; }

eloquent

(In Laravel

Set$connectionVariables

in the model

class SomeModel extends Eloquent { protected $connection = 'pgsql'; }

Trading Mode

DB::transaction(function () { DB::connection('mysql')->table('users')->update(['name' => 'John']); DB::connection('pgsql')->table('orders')->update(['status' => 'shipped']); });

or

DB::connection('mysql')->beginTransaction(); try { DB::connection('mysql')->table('users')->update(['name' => 'John']); DB::connection('pgsql')->beginTransaction(); DB::connection('pgsql')->table('orders')->update(['status' => 'shipped']); DB::connection('pgsql')->commit(); DB::connection('mysql')->commit(); } catch (\Exception $e) { DB::connection('mysql')->rollBack(); DB::connection('pgsql')->rollBack(); throw $e; }

You can also define the connection at runtime via thesetConnectionmethod or theonstatic method:

class SomeController extends BaseController { public function someMethod() { $someModel = new SomeModel; $someModel->setConnection('pgsql'); // non-static method $something = $someModel->find(1); $something = SomeModel::on('pgsql')->find(1); // static method return $something; } }

---

Test version (Updated)