Marcin Cieslak schrieb:
After a failure to install API database on ptolemy in reasonable amount of time, I have come to conclusion that we might not need full API database (ca. ~1 TB) for now, not at least for production Wikimedia use.
May I ask you where you got this dump from? It's not an official one, is it?
What Wikimedia might need is the Mapnik database (ca. 70GB for rendering)
- this is what we have now on Cassini (although outdated - but see neighbouring
thread).
Full API database - once *finally* imported - would have been probably more useful for tool developers, hacking properties and some other features of geodata (maybe even history).
Yes, it is! It may be the only way to get some historic information needed, to eg. show a changeset in some kind of cool diff-view or to develop smart changeset-revert tools (see [1] and [2] for this problem, the OSM-API does not and will in the near future not provide this kind of information).
However, only Ptolemy (currently WMF production server) has disk space available for the whole API database; I do not see - but I might be wrong
- currently use for this database (except for genering mapnik DB out of it)
- for the WMF production environment.
I do not see either. If Ptolemy won't be accessible by cassini and it's only task will be serving the mapnik render with gis-data, then I don't think we'll that much HD-Space on it. I'm unsure about the remaining system configuration (e.g. ptolemy has 8GB more RAM).
So we might have add disk space to Cassini to have space for the full API database, and start importing it there. But... Maybe we could just switch servers? (i.e. current Cassini reconfigure as WMF-production Ptolemy and current Ptolemy reinstall as a toolserver database).
Yes, please do this!
Sure, it will require stopping tools for a while and do some IP (or maybe even rack-juggling) but maybe it's the solution.
I don't think there are too many *live* tools on cassini (although there may be some in development stage).
We might alternatively give up on full database API altogether and just run Mapnik DB on the Ptolemy as we have.
The simple question is: do we want tools that can play with the history of osm-objects or not. If we want, we'll have to supply the necessary data.
Peter