On Monday 10 January 2011, Kai Krueger wrote: > Depending on how far you really want to scale, I think a lot of the > necessary components are already in place. If none of the "out of the box" > solutions such as the new Postgresql 9.0 replication mechanism work, we > would possibly get a fair distance by splitting out reads and writes onto > separate db servers.
This is how the postgres 9 replication works. The replicating servers become "hot standbys" which you can use for read requests. So in theory the read requests could be scaled quite easily once set up. Atomicity of the API would potentially suffer though. robert. _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
