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