Design a tribe membership system

Design a tribe membership platform that allows users to create tribes, join existing tribes, and manage memberships at scale while handling high transaction throughput, database contention, data consistency, and burst traffic.