On Tue, 20 Mar 2012 11:35:02 -0700, Asher Feldman afeldman@wikimedia.org wrote:
On Tuesday, March 20, 2012, Roan Kattouw roan.kattouw@gmail.com wrote:
So yeah /normally/ you hit DB servers at random and different servers might respond differently (or be lagged to different degrees), but in this particular case it was always the same DB server returning the same lag value. Nothing strange going on here, this is how the maxlag parameter works.
How do you feel about a switch to change that behavior (maxlag - 1)? It would be nice to be continue guiding developers towards throttling API requests around maxlag without complicating schema migrations by requiring config deployments before and after every db for this reason only.
Why don't we have a system to allow databases to be automatically taken out of the LB temporarily?