Failover © 2018 Percona. 32 Traffic Management Scaling with Large Number of Connections Routing Traffic to Right “Shard” Read-Write Splitting Load Management Avoiding “Dead” Nodes © 2018 Many Custom App-Layer Implementation Exists © 2018 Percona. 49 Thinking about Sharding Query Routing to the right Shard Data Aggregation for Cross-Shard Queries Shard Balancing © 2018 Percona.

[logger] level = INFO [routing:read_only] bind_address = 127.0.0.1 bind_port = 3308 destinations = 192.168.1.141:3306, 192.168.1.42:3306, 192.168.1.43:3306 mode = read-only [routing:read_write] bind_address