I am reading pros and cons about importing the osm database into my own mysql server but since there are so many variations in posts, I thought I would ask here to get the most current version.
I want to have a local osm db so that I don't have to use others bandwidth and to speed up the reads.
I will install the entire db and then only update as needed.
The server already has MySQL installed on it and I am thinking of using it for development and later will likely build a new server for OSM using Postgress or something else. Apparently, geographic extensions are missing when using MySQL, unless that is old information on the wiki?
Cannot afford an optimized service at this time but perhaps in the near future.
Wondering what the pros and cons are as well as what method to use for importing the xml file.