From OpenStreetMap Wiki
Jump to navigation Jump to search

Discuss database here

mysqldump --no-data

Can we see mysqldump --no-data?

Perhaps a couple recent takes of SHOW GLOBAL STATUS?

--User:Snoyes 04:35, 6 February 2009

See Database schema#MySQL for this. Note that the best way to create these tables in a development environment is to have the Ruby on Rails framework do it automatically based on the models. Nice diagram of the models at The Rails Port/Railroad diagrams
-- Harry Wood 10:45, 6 February 2009 (UTC)


Has anyone considered/looked into using a NoSQL DBMS such as Cassandra or Hypertable? More info:

The DB is over a quarter TB IIRC and getting bigger. Might want to consider scalability issues.

--Recruit0 06:44, 22 February 2011 (UTC)

People certainly have looked into it. We get a lot of people suggesting different database, schemas, and data models for the central OSM servers. But in general the planet.osm downloads are available for anyone to experiment on their own servers. Unless/until someone does that and proves that it works way better than the standard relational set-up with have, there's not likely to be any serious consideration of moving over to a new architecture.
Of Course OpenStreetMap is a big ecosystem. The central database (which this wiki page describes) is not the be all and end all. Some people are developing tools to populate MongoDB (see Osmo, and I thought there was another one "mongosm" or something) , and I think there are some live services/tools running off them.
-- Harry Wood 12:30, 22 November 2011 (UTC)
There are also experiments with CouchDB, see OSMCouch or talk to User:Emka. An more ore less complete list of used databases ist available at Databases#Choice_of_DBMS. --Saerdnaer 13:05, 23 November 2011 (UTC)


It there a raw sql dump available besides Planet.osm?--Kozuch 15:27, 22 December 2011 (UTC)

As far as I know there isn't. There are many different formats we could provide the whole planet in (And when I say "we" I mean anyone with a server who wishes to download the planet, keep it updated, and offer it up in a converted format). So certainly it's a possibility.
An obvious limitation of offering up raw SQL dumps, is that they would have a particular database schema in mind. The database schema used by The Rails Port is best fit for the OSM data, and I guess that's what you have in mind. But there are other database schemas, for example a lot of people load the planet data into a PostGIS database (with spatial columns) for use with software like Mapnik.
-- Harry Wood 23:43, 22 December 2011 (UTC)