hi folks,
Sun has agreed to donate an additional server to act as a login server for Zedler (what login-services does now), replacing the login-services zone. this will allow MySQL to run without influence from CPU-consuming user processes.
more details (and a more general announcement) to come later.
- river.
Hi all
Sun has agreed to donate an additional server to act as a login server for Zedler (what login-services does now), replacing the login-services zone.
cool!
this will allow MySQL to run without influence from CPU-consuming user processes.
Hm... how much CPU eating user processes do we see currently? Does this split really make sense?
I would propose to split a different way: have a "research" or "analysis" server (few but heavy queries) separate from the "tools" server (web service, many relatively fast queries). I believe this would help more to make the server(s) more useful.
-- Daniel
On 4/26/06, Daniel Kinzler daniel@brightbyte.de wrote:
cool!
this will allow MySQL to run without influence from CPU-consuming user processes.
Hm... how much CPU eating user processes do we see currently? Does this split really make sense?
I would propose to split a different way: have a "research" or "analysis" server (few but heavy queries) separate from the "tools" server (web service, many relatively fast queries). I believe this would help more to make the server(s) more useful.
I'd propose something slightly different..
We run two servers:
1. Back end, live replicated databases. And mature 'production' tools which require greater reliability. 2. Front end, most tools that are not so sensitive to toolserver load, all tool development, and additional analysis databases which are not live updated.. but which may contain extra indexes, and other fields to help some tools work.
Thoughts?
Daniel Kinzler:
I would propose to split a different way: have a "research" or "analysis" server (few but heavy queries) separate from the "tools" server (web service, many relatively fast queries). I believe this would help more to make the server(s) more useful.
this would make more sense with two MySQL instances on a single server (using separate disks). MySQL itself doesn't use all that much CPU.
- river.
Perhaps we should first find an admin .....
-- [[:de:Benutzer:Flacus]][[:de:Benutzer:FlaBot]] http://tools.wikimedia.de/~flacus/IWLC/
River Tarnell:
this would make more sense with two MySQL instances on a single server (using separate disks). MySQL itself doesn't use all that much CPU.
i should add that zedler is a four-CPU machine with two sockets populated. it can also take dual-core Opterons, for a total of eight cores if CPU use does become an issue in the future.
(unfortunately though dual-core 8xx CPUs are very expensive.)
- river.
toolserver-l@lists.wikimedia.org