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