[OSM-talk] New hardware for servers

Andy Robinson Andy_J_Robinson at blueyonder.co.uk
Tue Jul 3 16:33:56 BST 2007


Yann wrote:
>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.

Cheers

Andy

>
>Yann Hamon
>
>
>







More information about the talk mailing list