Model模型
// app/Models/Paragraph.php
...
public function getNewModel($memberId)
{
$this->setConnection('paragraph');
$this->setTable('paragraph_'. $memberId % 500);
return $this;
}
// app/Models/Article.php
...
public function getNewModel($platformId, $forceIndex = null)
{
$this->setConnection('article');
if (is_null($forceIndex)) {
$this->setTable('articles_' . $platformId);
} else {
$this->setTable(DB::raw("articles_${platformId} FORCE INDEX(${forceIndex})"));
}
return $this;
}
db配置
// app/config/database.php
...
'paragraph' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => 'paragraph',
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => env('DB_PREFIX', ''),
'strict' => true,
'engine' => null,
],
'article' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => 'article',
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => env('DB_PREFIX', ''),
'strict' => true,
'engine' => null,
],