Replication and Sharing Combinations – Stack Exchange Database Administrators

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

For example, is it possible to replicate a small table to avoid joins between fragments while a large table is shared? Like that:

  • Node 1

    • Table orders_male
    • Table kind
  • Node 2

    • Table orders_female
    • Table kind

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