ARCHIVES

Modern distributed systems often face the "broadcast query" bottleneck when data is horizontally sharded across isolated database instances. Traditional stateless orchestration layers fail to maintain data affinity, leading to increased latency and transactional inconsistency. This paper presents the "Intelligent Router" - a stateful orchestration pattern that leverages a Transactional Outbox and Metadata-Driven Routing to ensure strict data affinity and "at-least-once" delivery. By implementing a decentralized master election and heartbeat tracking mechanism, the proposed architecture eliminates the overhead of global distributed transactions while maintaining 100% idempotency. We provide a formal definition of the routing logic and present experimental results from a high-scale production environment demonstrating a 73% reduction in cross-node latency and improved fault tolerance in federated backend environments