[OSM-talk] New hardware for servers
Andy_J_Robinson at blueyonder.co.uk
Tue Jul 3 16:33:56 BST 2007
>Sent: 03 July 2007 3:59 PM
>To: talk at openstreetmap.org
>Subject: [OSM-talk] New hardware for servers
> >> Let me ask you, and more generally, the community, what would
> >> people like to see money being spent on (both large and small
> >> items) that would most help the project?
> > I would love to see a second database server which replicates data
> > from the #1 database server (only "current" tables) and serves all
> > read requests from there. Only write requests should go to the #1
> > database server. I hope that this will considerably increase
> > performance and enable us to allow larger bounding boxes and more
> > elements for downloading. The whole thing could also be the first
> > step to wider replication.
> I believe that the web server, and the general horribleness of
> rails and libxml2 for this particular task, are just as much of
> a bottleneck here as the database, if not more.
> Is MySQL replication "real time" enough for this by the way? In
> other words if I do a download from a slave is what I get going
> to be good enough to base an upload to the master on?
>Hello, looking at the munin stats, I think there are several points where
>the configuration of mysql and apache could be improved; is there a sys-
>admin mailing list for openstreetmap? Who should I talk to to get involved
>there? I sent two mails to steve, but they stay unanswered :(
No separate mailing list at the moment but a post to the dev list with some
specific recommendations will usually get a response. Be prepared to back up
you assumptions with specific testing results to get heard though.
More information about the talk