[OSM-dev] About rendering and editing databases

Nick Hill nick at nickhill.co.uk
Fri Apr 28 10:41:40 BST 2006

Immanuel Scholz wrote:
>>Should rendering DB be the same as editing DB? Experience (wikipedia)
>>says no, doesn't it...

> I'd say we should have many rendering engines on top of many replica
> databases and one main database (with editing capabilities and a simple
> rendering). This way, most (if not all) read requests will draw from the
> backuped databases while it is still possible to verify your latest change
> in the main database.

If all databases are the same, then this can be achieved easily through 
database replication. The replica databases will be updated almost 

As the project grows, we will need a database farm.

Ultimately, we should have one server which never serves selects, only 
inserts, to keep editing smooth. It is much more costly for inserts to 
fail than for selects to be slow or fail.

More information about the dev mailing list