Databases Reference
In-Depth Information
node. The
shard_new
and
shard_archive
columns tell you which shard numbers
hold the data.
Load Balancing
The basic idea behind load balancing is simple: to share the workload among a
collection of servers. The usual way to do this is to place a load balancer (often a spe-
cialized piece of hardware) in front of the servers. The load balancer then routes in-
coming connections to the least busy available server.
Figure 11-9
shows a typical load-
balancing setup for a large website, with one load balancer for the HTTP traffic and
another for MySQL traffic.
Figure 11-9. Typical load-balancing architecture for a read-intensive website
Load balancing has five common goals:
Scalability
Load balancing can help with certain kinds of scalability strategies, such as read-
write splitting to read from replicas.
