<html theme="default-light"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body text="#000000">Looking at it from a TRA (Threat Risk
Assessment) point of view OpenStreetMap is not totally dependent on one
central database being up and working.<br>
<br>
The primary database is fed by edits but if the database happens to get
encrypted by Malware the backup and copies are still there. The tiles
on the tile server will still display, OSMAND will still work etc.<br>
<br>
We strongly suspect that we are not running pure ISO standard SQL, which
is fine but that does mean we need to take into account other linked
databases so it would not just be the cost of the central database but
many other servers and databases that would need to align and that is
not trivial. Some other users will have budgets and capacity to move
others will not. There is a lot of documentation tied back to the
existing system which would need to be looked over. Change management
is not always simple.<br>
<br>
For good database performance we need memory and lots of it so that
rules out playing with SQL server express.<br>
<br>
My concern that we weren't exactly mainstream with our database size has
been reassured that there are other databases running on the same software
that are larger.<br>
<br>
Since we deal with a large number of new mappers who do odd things I get
the impression that our procedures are robust and to be honest quite a
lot of security is good procedures.<br>
<br>
So thank you for your inputs, especially those who raised or addressed
specific issues.<br>
<br>
Cheerio John<br>
<br>
<span>Mateusz Konieczny via talk wrote on 2020-07-25 08:07:</span><br>
<blockquote type="cite" cite="mid:MD4rkAj--F-2@tutanota.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div>And database size limit is just a start :)<br></div>
<div><br></div>
<div>It is artificially limited to 1G of RAM. I am curious how long
planet import<br></div>
<div>with 1GB of RAM would run :)<br></div>
<div><br></div>
<div>Jul 25, 2020, 13:31 by <a class="moz-txt-link-abbreviated" href="mailto:jwhelan0112@gmail.com">jwhelan0112@gmail.com</a>:<br></div>
<blockquote class="tutanota_quote" style="border-left: 1px solid
#93A3B8; padding-left: 10px; margin-left: 5px;"><div dir="auto"><div>And
as we start to fill the database with buildings even those might not
fit.<br></div><div dir="auto"><br></div><div dir="auto">Thanks John<br></div></div><div><br></div><div
class=""><div class="" dir="ltr">On Sat, Jul 25, 2020, 05:19 Hartmut
Holzgraefe <<a href="mailto:hartmut@php.net" rel="noopener
noreferrer" target="_blank" moz-do-not-send="true">hartmut@php.net</a>>
wrote:<br></div><blockquote style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex" class=""><div>On 24.07.20 23:55, john
whelan wrote:<br></div><div> > Microsoft SQL Server Express is a free
limited version of SQL server <br></div><div> > that may well do for
many users.<br></div><div> <br></div><div> reading express edition
limitations I see:<br></div><div> <br></div><div> * Maximum relational
database size: 10GB<br></div><div> <br></div><div> That would only be
enough for the smallest of OSM regional extracts ...<br></div><div> <br></div><div>
-- <br></div><div> hartmut<br></div><div> <br></div><div>
_______________________________________________<br></div><div> talk
mailing list<br></div><div> <a rel="noopener noreferrer" target="_blank"
href="mailto:talk@openstreetmap.org" moz-do-not-send="true">talk@openstreetmap.org</a><br></div><div>
<a target="_blank" rel="noopener noreferrer"
href="https://lists.openstreetmap.org/listinfo/talk"
moz-do-not-send="true">https://lists.openstreetmap.org/listinfo/talk</a><br></div></blockquote></div></blockquote>
<div><br></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
talk mailing list
<a class="moz-txt-link-abbreviated" href="mailto:talk@openstreetmap.org">talk@openstreetmap.org</a>
<a class="moz-txt-link-freetext" href="https://lists.openstreetmap.org/listinfo/talk">https://lists.openstreetmap.org/listinfo/talk</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<div>Sent from <a href="https://www.postbox-inc.com"><span style="color:
rgb(0, 157, 247);">Postbox</span></a></div></div>
</body></html>