#StackBounty: #replication #sharding #scalability Replication and sharding combinations

Bounty: 100

In modern relational databases, what combinations of replication and sharding are possible?

Actually, I’m interested in the following strategy. Is it possible to replicate a small table in order to avoid cross-shard joins whereas a large table is sharded? Like this:

  • Node 1
    • Table orders_male
    • Table genders
  • Node 2
    • Table orders_female
    • Table genders

Both order_male and order_female contain foreign key that references the genders table.

Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.