[josm-dev] JOSM Server

[Dirk Stöcker]

Hello,

additional to Pauls text some background information:

We had server troubles regarding the database performance for about 2 
years now. Mainly these issues have been caused by the increasing activity 
of you all which resulted in growing database and activity. SqLite is a 
very simple database and got to its limits. The JOSM-Trac was too 
successful (one of the reasons why there are so many spam attempts :-)

To fix the database issues I wanted to change to postgresql instead, which 
is more suitable for the current requirements. As the change of the 
database is a big issue and the current server had no IPV6 connectivity I 
simply asked Hetzner for sponsoring a new server not really expecting a 
positive answer. But they said yes immediatelly, so database upgrade also 
got server move. I promised them some unobtrusive advertising for their 
sponsoring, but there is no contract enforcing this.

BTW: Why Hetzner - I use them private and in company a lot and they are 
pretty good.

So I got a complete new server instead of only a new database. The hosting 
with FOSSGIS was fine, nothing to blame about this (the IPV6 issue is due 
to the fact GFZ has no IPV6 yet). Thought an own server is always a bit 
better. So instead of only doing the database update we also have a new 
server now (still database migration was much more work than the server 
move - we have a pretty good guide for server migration right now, we did 
it 2 times in the past :-).

Regarding new server, database: There needs to be a little more 
finetuning, so the setup does not exceed the available ressources - The 
defaults of web server and database are very ressource hungry for no good 
reason. Please report any issues - I expect some more troubles in the next 
days, but hopefully we have some time until we exceed limits next time.

So lots of thanks again to FOSSGIS who provided server space for us for 
such a long time. As there is enough demand for computer power in the OSM 
community I believe the old server soon will get used for other fancy 
purposes.

Ciao
-- 
http://www.dstoecker.eu/ (PGP key available)