Marco Schuster schrieb:
But we have to think how we prevent lagging in
future(lag for wikis is
again rising :-(). A way to solution would be a re-arrangement of the
servers and the structure:The MySQL servers are splitted up. So we got
an one for enwp, another one for dewp and so on for the 5 biggest wikis.
The left wikis are stored on the left server. All servers replicate to
the toolserver.
It's not that easy to prevent the lag, unless you want a tool-*server*
and not
a tool-*cluster*. It's a bit crazy, we want to replicate the data of a
whole cluster
on one single server -- and we want it not to lag (Tim's words).
Existing MySQL servers in knams and paris cluster
should be converted to
apache/squid servers.
When an Edit happens, its data will be transported to the corresponding
mysql server in Florida. Then this server sends the data back to all
Apaches(not via HTTP-an persistent connection would be better here!) and
the Apaches generate now new versions for the page which has been edited
and the corresponding logs.
That's how we have it right now.
Leon