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.
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.
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.
For good database performance we need memory and lots of it so that
rules out playing with SQL server express.
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.
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.
So thank you for your inputs, especially those who raised or addressed
specific issues.
Cheerio John
Mateusz Konieczny via talk wrote on 2020-07-25 08:07:
And database size limit is just a start :)
It is artificially limited to 1G of RAM. I am curious how long planet
import
with 1GB of RAM would run :)
Jul 25, 2020, 13:31 by jwhelan0...@gmail.com:
And as we start to fill the database with buildings even those
might not fit.
Thanks John
On Sat, Jul 25, 2020, 05:19 Hartmut Holzgraefe <hart...@php.net
<mailto:hart...@php.net>> wrote:
On 24.07.20 23:55, john whelan wrote:
> Microsoft SQL Server Express is a free limited version of
SQL server
> that may well do for many users.
reading express edition limitations I see:
* Maximum relational database size: 10GB
That would only be enough for the smallest of OSM regional
extracts ...
--
hartmut
_______________________________________________
talk mailing list
talk@openstreetmap.org <mailto:talk@openstreetmap.org>
https://lists.openstreetmap.org/listinfo/talk
_______________________________________________
talk mailing list
talk@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk
--
Sent from Postbox <https://www.postbox-inc.com>
_______________________________________________
talk mailing list
talk@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk
