![]() Shards are typically databases within an elastic pool. An elastic query is used to query or compile reports across many shards. Sharding can be performed and managed using (1) the elastic database tools libraries or (2) self-sharding. With this approach, the schema is identical on all participating databases. Horizontal Partitioning - Sharding (Topology 2): Data is partitioned horizontally to distribute rows across a scaled out data tier. ![]() Common use cases with this topology require one to query across or to compile reports across tables in several databases. For instance, all tables for inventory are on one database while all accounting-related tables are on a second database. That means that the schema is different on different databases. Typically, different sets of tables reside on different databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |