Embed Notice

In the end, many years later, a solution would be established with DIRECT connections from the clients to a read-pool of replicas,

using Zookeeper as a place where databases registered themselves as ready-to-serve,

and clients subscribed to read-pools in Zk,

materialized them as files in /etc/bookings/db on their harddisk

and lb'ed using a random file from these endpoint lists.

This would show up properly in SHOW PROCESSLIST, would survive Zk downtime (the lists freeze) and would be …