4

currently I'm using PostgreSQL/PostGIS for a small spatial project. Last week the project manager asked me if we could migrate to MySQL with Spatial Extension.

I know MySQL but have no experience with the Spatial Extension. I heard that the extension is not very fast and might contain some bugs.

Now my question - is MySQL Spatial extension stable and fast enough to be considered for an online database with about 20000 spatial operations a day?

The operations are just the standard stuff like: - export to KML - point in polygon - overlapping polygon

The database has one GB of spatial data.

Improve this question
6
  • No the MySQL Spatial Extension is still in development. You will find your current POSTGIS version more stable and more spatial functions than the MYSQL Spatial. see mysqlperformanceblog.com/2013/10/21/… You can still test it on a test environment
    – Mapperz ♦
    Commented Feb 4, 2014 at 21:01
  • @Mapperz: Care to (expand and) post that as an answer, please?
    – Martin F
    Commented Feb 4, 2014 at 21:10
  • Is "SOPD spatial operations per day" enough info? What about "CUPM concurrent users per minute" and "SOPM spatial operations per minute"? I'm not sure how I would use the different info -- i'm just wondering if there are more rigorous/standard benchmarks for assessing performance.
    – Martin F
    Commented Feb 4, 2014 at 21:16
  • It might help if we knew why the PM wanted to move away from PostGIS to another solution (in this case MySQL). I have trouble believing any experienced project manager would want to change infrastructure without a sound reason. What are you hoping to achieve?
    – BradHards
    Commented Feb 4, 2014 at 23:13
  • @martin f, I don't know which indicators are best for this question, I just wanted to provide a rough picture about the type and load of the implemented application. The SOPM should be around 100 and the 'CUPM'at about 30 in peak hours - so nothing serious.
    – ABX
    Commented Feb 5, 2014 at 8:08

1 Answer 1

Reset to default
0

Thanks Mapperz, the link helped to get a feeling about the status of the spatial plugin.

http://www.mysqlperformanceblog.com/2013/10/21/using-the-new-spatial-functions-in-mysql-5-6-for-geo-enabled-applications/

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.