Posts | Mark Story

One approach to scaling out a database for a multi-tenant application is to horizontally shard or partition the data by customer. This often takes the form of having multiple identical copies of an application’s schema in each shard. For example customer A’s data would be in shard 1, while customer C’s data would be in shard 2. Often, in addition to the sharded databases, there is a lookup databas

[ymm1x]

sharding example (in cakephp ~3.2)