database.php 3.04 KB
<?php

return [

	'fetch' => PDO::FETCH_CLASS,
	'default' => 'mysql',

	'connections' => [

		'sqlite' => [
			'driver'   => 'sqlite',
			'database' => storage_path().'/database.sqlite',
			'prefix'   => '',
		],

		'mysql' => [
			'driver'    => 'mysql',
			
			'read' => [
					'host' => env('DB_HOST', 'localhost'),
			],
			'write' => [
					'host' => env('DB_HOST', 'localhost'),
			],
			
			'database'  => env('DB_DATABASE', 'kstych_framework'),
			'username'  => env('DB_USERNAME', 'root'),
			'password'  => env('DB_PASSWORD', ''),
			'charset'   => 'utf8',
			'collation' => 'utf8_unicode_ci',
			'prefix'    => '',
			'strict'    => false,
		],
		'Delhi' => [
			'driver'    => 'mysql',
			
			'read' => [
					'host' => '10.14.130.50',
			],
			'write' => [
					'host' =>'10.14.130.50',
			],
			
			'database'  => 'flexydial',
			'username'  => env('DB_USERNAME', 'root'),
			'password'  => env('DB_PASSWORD', 'yb9738z'),
			'charset'   => 'utf8',
			'collation' => 'utf8_unicode_ci',
			'prefix'    => '',
			'strict'    => false,
		],
		'server1' => [
			'driver'    => 'mysql',
			
			'read' => [
					'host' => '192.168.3.252',
			],
			'write' => [
					'host' =>'192.168.3.252',
			],
			
			'database'  => 'fullerton',
			'username'  => env('DB_USERNAME', 'root'),
			'password'  => env('DB_PASSWORD', 'yb9738z'),
			'charset'   => 'utf8',
			'collation' => 'utf8_unicode_ci',
			'prefix'    => '',
			'strict'    => false,
		],
		'Chennai' => [
			'driver'    => 'mysql',
			
			'read' => [
					'host' => '10.4.105.141',
			],
			'write' => [
					'host' =>'10.4.105.141',
			],
			
			'database'  => 'fullerton',
			'username'  => env('DB_USERNAME', 'root'),
			'password'  => env('DB_PASSWORD', 'yb9738z'),
			'charset'   => 'utf8',
			'collation' => 'utf8_unicode_ci',
			'prefix'    => '',
			'strict'    => false,
		],
		'Mumbai' => [
			'driver'    => 'mysql',
			
			'read' => [
					'host' =>'10.2.105.141',
			],
			'write' => [
					'host' => '10.2.105.141',
			],
			
			'database'  => 'fullerton_db',
			'username'  => env('DB_USERNAME', 'root'),
			'password'  => env('DB_PASSWORD', 'yb9738z'),
			'charset'   => 'utf8',
			'collation' => 'utf8_unicode_ci',
			'prefix'    => '',
			'strict'    => false,
		],

		'pgsql' => [
			'driver'   => 'pgsql',
			//'host'     => env('DB_HOST', 'localhost'),
			'read' => [
			    'host' => env('DB_HOST', 'localhost'),
			],
			'write' => [
			    'host' => env('DB_HOST', 'localhost')
			],
			'database' => env('DB_DATABASE', 'forge'),
			'username' => env('DB_USERNAME', 'forge'),
			'password' => env('DB_PASSWORD', ''),
			'charset'  => 'utf8',
			'prefix'   => '',
			'schema'   => 'public',
		],

		'sqlsrv' => [
			'driver'   => 'sqlsrv',
			'host'     => env('DB_HOST', 'localhost'),
			'database' => env('DB_DATABASE', 'forge'),
			'username' => env('DB_USERNAME', 'forge'),
			'password' => env('DB_PASSWORD', ''),
			'prefix'   => '',
		],

	],

	'migrations' => 'migrations',

	'redis' => [

		'cluster' => false,

		'default' => [
			'host'     => '127.0.0.1',
			'port'     => 6379,
			'database' => 0,
		],

	],

];