Gregory Maxwell wrote:
Because I can't even expect the nonexistent toolserver administration to perform the trivial action of turning off my account, I have deleted my ssh authorized key... thus my account is effectively disabled. So don't worry, you can go on doing nothing.
I'm in favour of giving you root access on the toolserver and a pppuser account for the main cluster, then you can do what you can with it. If you accepted the role and the others in control of the toolserver consented, I'd wish you luck, but I'm not sure how much you'd be able to do. The site is growing rapidly, and so is the data size and write load. We currently have somewhere around 500-600GB of InnoDB data across all our clusters. Zedler has 625GB total space in its main partition. If the data fits now, it won't leave much room, and it won't fit for long.
There's a reason we are splitting our databases into lots of different indepdently replicating clusters, that's because our servers were having increasing difficulty keeping up with the write load while still performing a useful amount of read load. Zedler is experiencing that problem too, there are apparently times of the day or week when it can't keep up with the write rate, given its existing read rate.
Now, with careful optimisation of the read load, including halting all non-critical reads when lag is over a certain value, it may be possible to keep the lag low, even when replicating the entire multi-master data set. But that will mean limiting the number of expensive queries. And how long will it last, anyway?
The point I'm getting at is that maybe it's not reasonable to expect a server of zedler's type to replicate every transaction that occurs anywhere in our site. If we want a complete, up-to-date copy of all data at knams, we probably need to dedicate more hardware to it.
In any case, I think giving Gregory root access would be a positive step forward. He is obviously very motivated towards the toolserver project (or at least was), and it's my understanding that he's capable as well. Could Kate and/or the e.V. give some comment on this?
-- Tim Starling