Databases Reference
In-Depth Information
Figure 4-9. Using read/write load balancers to direct requests to a cluster
The strategy used to implement consistent routing will vary by domain. Sometimes it's
good enough to have sticky sessions; other times we'll want to route based on the char‐
acteristics of the dataset. The simplest strategy is to have the instance that first serves
requests for a particular user thereafter serve subsequent requests for that user. Other
domain-specific approaches will also work. For example, in a geographical data system
we can route requests about particular locations to specific database instances that have
been warmed for that location. Both strategies increase the likelihood of the required
nodes and relationships already being cached in main memory, where they can be
quickly accessed and processed.
