I currently am using MySQL for all of my relational data. I have hit a crossroads with geo calculations. Since, MySQL does not have good support for spatial functions, I am contemplating on using Postgres's PostGIS extention.
But, for this I will have top run 2 DB servers (MySQL and Postgres) as I do not want to move away from InnoDb(for all the goods that it offers).
- Does implementing the functions cause any performance issues(lag)?
- Is the trouble worth it or should I move ahead with PostGIS?
Is moving the whole DB from MySQL to Postgres any good (Although I am not exactly considering this)?