enfil/sharding

Laravel 5.1 sharding

laravel-sharding

#

LEGACY!!!

CLOSED AND NOT SUPPORTED

#

Installation

Download package

composer require enfil/sharding, _(*1)

Add to Providers

Add Enfil\Sharding\ShardingServiceProvider::class, to the providers array in /config/app.php., _(*2)

Add to Aliases

Add 'ShardManager' => \Enfil\Sharding\Facades\ShardManager::class, to the alias list in /config/app.php., _(*3)

Publish config

php artisan vendor:publish --provider="Enfil\Sharding\ShardingServiceProvider" --tag="config" --force, _(*4)

Configuration

You can configurate sharding for all your services in the sharding.php config file located in the config directory., _(*5)

Usage

First of all you should set your service:, _(*6)

\ShardManager::setService('auth');, _(*7)

Adding data

When you're inserting any element into your database you should generate unique ID for it. You can get next id using:, _(*8)

$id = \ShardManager::getNextId();, _(*9)

Than you can choose shard (database connection) using:, _(*10)

$shard = \ShardManager::getShardById($id);, _(*11)

Now you can insert your data to current shard:, _(*12)

\DB::connection($shard)->table('t')->insert(
    [...]
);

After inserting you should increment id-generator:, _(*13)

\ShardManager::increment();, _(*14)

Selecting data

To select your data by id you should get a shard:, _(*15)

$shard = \ShardManager::getShardById($id);, _(*16)

Than you can get data from current shard:, _(*17)

DB::connection($shard)->table('t')->select(...);, _(*18)