With the introduction of different-capacity servers, we need to assign to nodes based on a proportion of expected maximum.

I think this is actually easier than I expected. Instead of ordering by actives, we order by actives/max_capacity. If this turns out to be too inefficient (shouldn't be with only a couple hundred rows), we can have the nightly actives update add % to a new column and order by that. This doesn't address how we get max_capacity into available_nodes (and mandates that max_capacity is now NOT NULL). We probably need to add it to the master config file for each node.

This requires the changes in 599133 or things will break horribly

In http://hg.mozilla.org/services/reg-server/rev/45868518b54a

Also need to do this to sreg

changes the select over to the reg version. Also appears to have removed a bunch of spaces.

Comment on attachment 520900 [details] [diff] [review] Uses the reg algorithm to assign nodes Wow. loads of whitespace diffs.

Why this is REOPENED ?